DATETIME and DATETIME-TZ literals

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.