List of expression elements / Date and time operators |
The DATE() operator converts an expression to a DATE value.
DATE [(expr)]
DATE() converts a character string, an integer or datetime expression to a DATE value.
When expr is a character string expression, it must properly formatted according to datetime format settings like DBDATE.
If expr is an integer expression, it is used as the number of days since December 31, 1899.
If you supply no operand, it returns a character representation of the current date in the format "weekday month day year".
MAIN DISPLAY DATE ( 34000 ) DISPLAY DATE ( "12/04/1978" ) DISPLAY DATE ( CURRENT ) END MAIN