Function
specifies the format in which date, time, and timestamp values are represented.
Format
<datetimeformat> ::=
EUR
| INTERNAL
| ISO
| JIS
| USA
Syntax Rules
1. The representation of a date value depends on the current format. In the list,
'YYYY' stands for a four-digit identifier of a year,
'MM' stands for a two-digit identifier of a month (01-12),
'DD' stands for a two-digit identifier of a day (01-31).
In all formats, except INTERNAL, leading zeros may be omitted in the identifiers of the month and day.
2. The representation of a time value depends on the current format. In the list,
'HHHH' stands for a four-digit identifier of an hour, or
'HH' stands for a two-digit identifier of an hour,
'MM' stands for a two-digit identifier of minutes (00-59),
'SS' stands for a two-digit identifier of seconds (00-59).
In all time formats, the identifier of the hour must consist of at least one digit. In the time format USA, the identifier of minutes can be omitted completely. In all the other formats, except INTERNAL, the identifiers of minutes and seconds must consist of at least one digit.
3. The representation of a timestamp value depends on the current format. In the list,
'YYYY' stands for a four-digit identifier of a year,
'MM' stands for a two-digit identifier of a month (01-12),
'DD' stands for a two-digit identifier of a day (01-31),
'HH' stands for a two-digit identifier of an hour (00-24),
'MM' stands for a two-digit identifier of minutes (00-59),
'SS' stands for a two-digit identifier of seconds (00-59),
'MMMMMM' stands for a six-digit identifier of microseconds.
In all date and time formats, the identifier of microseconds may be omitted. In all formats, except INTERNAL, the identifiers of the month and day must consist of at least one digit.
General Rules
1. The date and time format determines the representation in which date, time and timestamp values may be included in SQL statements and the way in which results are to be represented.
2. The date and time format is determined during the installation of the database.
3. A user can change the date and time format for his session by setting the SET parameters of the ADABAS components or by specifying the corresponding parameters when using programs.