Note: If you pass invalid data to the functions below, the apply engine fails and message SQD0080E is issued. For more information, see Common Apply Engine problems.
| Function | Description |
|---|---|
| AFTER | Add at time interval to a date, time or timestamp. |
| BEFORE | Returns the value of a date, time or timestamp resulting from subtracting a specified number of days, months, years, minutes, hours and/or seconds. |
| DATE2SMALLJUL | Converts a conventional date (YYYYMMDD) to small Julian date format (YYDDD). |
| DATEFMT | Formats a date value including conversion of two digit year to a four digit year. |
| DATETIME | Returns the current date and time. |
| DAY | Returns the day portion of a source date. |
| DAYNAME | Returns the name of a day from its number (0 through 7). |
| DAYOFWEEK | Returns the day number from the current date. |
| DAYS | Returns the number of days since 0000-03-01. |
| GMT2LOCAL | Converts a GMT timestamp of the form YYYY-MM-DD-HH.MI.SS to the local timestamp. |
| JULIAN | Derive a long Julian date value from a date. |
| JULIAN2DATE | Converts long Julian date to a conventional date in YYYYMMDD format. |
| LOCAL2GMT | Converts a GMT timestamp of the form YYYY-MM-DD-HH.MI.SS to the local timestamp. |
| MONTH | Returns the month number from a date. |
| MONTHNAME | Returns the name of the month from a month number. |
| SECONDS | Converts the time value in HH:MM:SS into the equivalent number of seconds. |
| SMALLJUL | Returns a small Julian date from the current date in YYDDD format. |
| SMALLJUL2DATE | Converts a small Julian date (YYDDD) into a date formatted as YYMMDD. |
| STORECLOCK | Returns the current eight byte Storeclock in a displayable hexadecimal character format of 16 bytes. |
| TIME | Returns the current time in HH.MM.SS format. |
| TIMESTAMP | Returns a timestamp value from the current date/time in YYYY-MM-DD-HH.MM.SS.mmmmmm format. |
| TODAY | Returns the current date in YYYYMMDD format. |
| WEEK | Returns the number of a week from a specified date in YYYYMMDD format. |
| WEEKDAY | sqdedate.c. |
| YEAR | Returns the current year value in YYYY format. |