You are here:

Date and time operators

Date and time operators are implemented to allow 4gl developers to easily manipulate date and time values in time expressions:

CURRENT	returns the current date and time of day retrieved from the system clock
DATE	converts character, integer, and datetime operands into DATE
DAY	returns the day portion of its DATE or DATETIME operand
EXTEND	converts its DATE or DATETIME operand to a DATETIME value of the specified precision and scale
MDY	creates a DATE value from three comma-separated integers
MONTH	returns the month portion of its DATE or DATETIME operand
TIME	converts the time-of-day portion of its DATETIME operand into a character string
TODAY	returns the current date retrieved from the system clock
UNITS	converts an integer expression to an INTERVAL value
WEEKDAY	returns the day of the week implied by its DATE or DATETIME operand
YEAR	returns the year portion of its DATE or DATETIME operand