-
/
,
.
;
:
"text"

Yes 

Punctuation and quoted text is reproduced in the result. 

AD
A.D.

Yes 

AD indicator with or without periods. 

AM
A.M.

Yes 

Meridian indicator with or without periods. 

BC
B.C.

Yes 

BC indicator with or without periods. 

CC
SCC

No 

One greater than the first two digits of a four-digit year; "S" prefixes BC dates with "-". For example, '20' from '1900'. 

D

Yes 

Day of week (1-7). 

DAY

Yes 

Name of day, padded with blanks to length of 9 characters. 

DD

Yes 

Day of month (1-31). 

DDD

Yes 

Day of year (1-366). 

DY

Yes 

Abbreviated name of day. 

E

No 

Abbreviated era name (Japanese Imperial, ROC Official, and Thai Buddha calendars). 

EE

No 

Full era name (Japanese Imperial, ROC Official, and Thai Buddha calendars). 

FF

Fractional seconds; no radix printed (see X format element below).

Example: 'HH:MI:SS.FF'. 

HH

Yes 

Hour of day (1-12). 

HH12

No 

Hour of day (1-12). 

HH24

Yes 

Hour of day (0-23). 

IW

No 

Week of year (1-52 or 1-53) based on the ISO standard. 

IYY
IY
I

No 

Last 3, 2, or 1 digit(s) of ISO year. 

IYYY

No 

4-digit year based on the ISO standard. 

J

Yes 

Julian day; the number of days since January 1, 4712 BC. Number specified with 'J' must be integers. 

MI

Yes 

Minute (0-59). 

MM

Yes 

Month (01-12; JAN = 01). 

MON

Yes 

Abbreviated name of month. 

MONTH

Yes 

Name of month, padded with blanks to length of 9 characters. 

PM
P.M.

No 

Meridian indicator with or without periods. 

Q

No 

Quarter of year (1, 2, 3, 4; JAN-MAR = 1). 

RM

Yes 

Roman numeral month (I-XII; JAN = I). 

RR

Yes 

Given a year with 2 digits:

• If the year is <50 and the last 2 digits of the current year are >=50, the first 2 digits of the returned year are 1 greater than the first 2 digits of the current year.

• If the year is >=50 and the last 2 digits of the current year are <50, the first 2 digits of the returned year are 1 less than the first 2 digits of the current year.

  See Also: Table 2-13

RRRR

Yes 

Round year. Accepts either 4-digit or 2-digit input. If 2-digit, provides the same return as RR. If you don't want this functionality, simply enter the 4-digit year. 

SS

Yes 

Second (0-59). 

SSSSS

Yes 

Seconds past midnight (0-86399). 

TZD

Yes 

Daylight savings information. The TZD value is an abbreviated time zone string with daylight savings information. It must correspond with the region specified in TZR.

Example: PST (for US/Pacific standard time); PDT (for US/Pacific daylight time). 

TZH

Yes 

Time zone hour. (See TZM format element below.)

Example: 'HH:MI:SS.FFTZH:TZM'. 

TZM

Yes 

Time zone minute. (See TZH format element above.)

Example: 'HH:MI:SS.FFTZH:TZM'. 

TZR

Yes 

Time zone region information. The value must be one of the time zone regions supported in the database.

Example: US/Pacific 

WW

No 

Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. 

W

No 

Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. 

X

Local radix character.

Example: 'HH:MI:SSXFF'. 

Y,YYY

Yes 

Year with comma in this position. 

YEAR
SYEAR

No 

Year, spelled out; "S" prefixes BC dates with "-". 

YYYY
SYYYY

Yes 

4-digit year; "S" prefixes BC dates with "-". 

YYY
YY
Y

Yes 

Last 3, 2, or 1 digit(s) of year.