DATE | Returns the current date in the pattern YYMMDD |
DATETIME | Returns the current date and time in the user-specified pattern or in the default pattern YYYYMMDDHHMISS999 |
DAYS | Returns the number of days corresponding to a date/time pattern string, or the number of days for today's date |
DAYSTODATE | Converts a number of days to a date/time pattern string |
DAYSTOSECS | Converts a number of days to a number of seconds |
REPATTERN | Takes a value holding a date in one pattern and returns that value converted to a date in a second pattern |
SECS | Returns the number of seconds corresponding to a date/time pattern string, or the number of seconds for today's date |
SECSTODATE | Converts a number of seconds to a date/time pattern string |
SECSTODAYS | Converts a number of seconds to a number of days |
TIME | Returns the current time in the pattern HHMISS999 |
VALIDDATE | Indicates if a string holds a valid date |
WEEKDAY | Returns the day of the week corresponding to the current day or specified DAYS value |
Y4DATE | Takes a date value with the pattern 'YYMMDD' and returns the date value with the two-digit year widened to a four-digit year |
Y4JULIAN | Takes a date value with the pattern 'YYDDD' and returns the date value with the two-digit year widened to a four-digit year |
Y4YEAR | Takes a date value with the pattern 'YY' and returns the date value with the two-digit year widened to a four-digit year |