Date-Time Operators

Autodesk Expression Builder

 
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.

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'