Date-Time Operators

A date-time property from the Get Values panel uses one of the following operators, depending on the field type. If you are an advanced user, you can also add one of these operators to an expression if you know its FDO syntax. These operators are not available from a list.

The Date-Time operators are parsed using the standard SQL literal strings:

• DATE 'YYYY-MM-DD'
• TIME 'HH:MM:SS[.sss]'
• TIMESTAMP 'YYYY-MM-DD HH:MM:SS[.sss]'

To use other formats, use TODATE or TOSTRING instead. See Conversion Options.

Function	Definition	Syntax	Example
DATE	Converts the string you specify into a date value using the format you choose from a list.	DATE 'string'	DATE '1971-12-24'
TIME	Converts the string you specify into a time value using the format you choose from a list.	TIME 'string'	TIME'11:00:02'
TIMESTAMP	Converts the string you specify into a date and time value using the format you choose from a list.	TIMESTAMP 'string'	TIMESTAMP '2003-10-23 11:00:02'