DateTime
From Team Developer SqlWindows Wiki
Revision as of 12:54, 12 September 2008 by 62.58.16.59 (Talk)
This page covers datetime datatype tips & tricks.
Contents |
How to strip elements from a DateTime
The next function is able to strip certain parts from a datetime.
So with this it is possible to construct a new datetime value with only the wanted elements.
Milliseconds are allways stripped.
Function: PALDateConstruct Returns Date/Time: Parameters Date/Time: pdtDateTime Boolean: pbYearMonthDays Boolean: pbHoursMinutes Boolean: pbSeconds Local variables Number: nYear Number: nMonth Number: nDay Number: nHour Number: nMinute Number: nSecond Actions If pbYearMonthDays Set nYear = SalDateYear( pdtDateTime ) Set nMonth = SalDateMonth( pdtDateTime ) Set nDay = SalDateDay( pdtDateTime ) If pbHoursMinutes Set nHour = SalDateHour( pdtDateTime ) Set nMinute = SalDateMinute( pdtDateTime ) If pbSeconds Set nSecond = SalDateSecond( pdtDateTime ) Return SalDateConstruct( nYear, nMonth, nDay, nHour, nMinute, nSecond )
So to strip of the seconds from the current datetime
dtTodayNoSeconds = PALDateConstruct( SalDateCurrent( ), TRUE, TRUE, FALSE )
Enter new tip title here
Enter new tip description here