Logical Operators
Operators
Functions
Date-Time Operators
When you insert a date-time property from the Get Values panel into your expression, that value 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.