DATETIME and DATETIME-TZ literals
- Last Updated: January 16, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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:
|
You can also use the following literal format:
|
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.