Filter
Top Products
130
Chapter 8
Format Examples
DD/MM/YYYY 15/01/1963
MM/DD/YY 01/15/63
MM/DD/YYYY 01/15/1963
DD-MM-YY
15-01-63
DD-MM-YYYY
15-01-1963
MM-DD-YY 01-15-63
MM-DD-YYYY
01-15-1963
DD.MM.YY
15.01.63
DD.MM.YYYY
15.01.1963
MM.DD.YY
01.15.63
MM.DD.YYYY
01.15.1963
DD-MON-YY
15-JAN-63, 15-jan-63, 15-Jan-63
DD/MON/YY
15/JAN/63, 15/jan/63, 15/Jan/63
DD.MON.YY
15.JAN.63, 15.jan.63, 15.Jan.63
DD-MON-YY
YY
15-JAN-1963, 15-jan-1963, 15-Jan-1963
DD/MON/YY
YY
15/JAN/1963, 15/jan/1963, 15/Jan/1963
DD.MON.Y
YYY
15.JAN.1963, 15.jan.1963, 15.Jan.1963
MON YYYY
Jan 2004
q Q YYYY
Date r epresented as a digit (1–4)
representing the quarter followed by
the letter Q and a four-digit year—for
example, 25 December 2004 would be
represented as 4 Q 2004.
ww WK YYYY
Two-digit number representing the week
of the year followed by the letters WK
and then a four-digit year. The w eek of
the year is calculated assuming that the
first day of the week is Monday and there
is at least one day in the first week.
Time
The CLEM language supports the following time formats.
Format Examples
HHMMSS
120112, 010101, 221212
HHMM 1223, 0745, 2207
MMSS
5558, 0100
HH:MM:SS
12:01:12, 01:01:01, 22:12:12
HH:MM
12:23, 07:45, 22:07
MM:SS
55:58, 01:00
(H)H:(M)M:(S)S
12:1:12, 1:1:1, 22:12:12
(H)H:(M)M
12:23, 7:45, 22:7
(M)M:(S)S
55:58, 1:0
HH.MM.SS
12.01.12, 01.01.01, 22.12.12
HH.MM
12.23, 07.45, 22.07