ABL allows two formats for DATETIME and DATETIME-TZ literals. The formats are the same for both DATETIME and DATETIME-TZ. The first format follows the ISO8601 standard:
9999-99-99THH:MM:SS.SSS+HH:MM
You can also use the following literal format:
"99-99-9999 HH:MM:SS.SSS+HH:MM"
The literal must be in quotes because of the space between the date and time. The date part must be in month/day/year order (like DATE literals).
You can omit all or part of the seconds, as well as the time zone offset.
The AVM evaluates the literals at run time. If a time zone offset is specified for a DATETIME literal, the literal is converted to the local time of the session. If a time zone offset is not specified for a DATETIME-TZ literal, the DATETIME-TZ uses the session's time zone offset.
