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