A date-time property from the Values Pane 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:
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' |