13.2 Date Formats
Date Built-In Functions may use one or more of the following formats as arguments and/or return values. The relevant Built-In Function's description tells you which format is used as arguments and/or return values.
Code | Format of Date |
|---|---|
A | System date format |
B | DDMMYY |
C | DD/MM/YY |
D | YYMMDD |
E | YY/MM/DD |
F | MMDDYY |
G | MM/DD/YY |
H | DDMMYYYY |
I | DD/MM/YYYY |
J | YYYYMMDD |
K | YYYY/MM/DD |
L | MMDDYYYY |
M | MM/DD/YYYY |
N | DDMMMYY (e.g. 03JUL87) |
O | DDMMMYYYY (e.g. 03JUL1987) |
P | DDxx MMMMMMMMM YY (e.g. 16TH SEPTEMBER 87) |
Q | DDxx MMMMMMMMM YYYY (e.g. 16TH SEPTEMBER 1987) |
R | DDD (e.g. MON, TUE, WED, etc). |
S | DDDDDDDDD (e.g. MONDAY, TUESDAY, WEDNESDAY, etc). |
T | DDDDDDDDDD (in selected language e.g. LLLLLLLLLL). |
U | MMMMMMMMMM (in selected language e.g. LLLLLLLLLL). |
V | 8 digit system date format |
W | YYMM |
X | MMYY |
Y | YYYYMM |
Z | MMYYYY |
1 | CYYMMDD |