Element

Description

Date Format

SCC or CC

Centry; S prefixes BC date with -

YYYY or SYYYY

Year; S prefixes BC date with -

YYY or YY or Y

Last 3, 2, or 1 digits of year

Y,YYY

Year with comma in this position

IYYY, IYY, IY, I

4, 3, 2, or 1 digit year based on the ISO standard

SYEAR or YEAR

Year spelled out; S prefixes BC date with -

BC or AD

BC/AD indicator

B.C. or A.D.

BC/AC indicator with periods

Q

Quarter of year

MM

Month, two-digit value

MONTH

Name of month padded iwth blanks to length of 9 characters

MON

Name of month, three-leter abbreviation

RM

Roman numeral month

WW or W

Week of year or month

DDD or DD or D

Day of year, month or week

DAY

Name of day padded iwth blanks to length of 9 characters

DY

Name of day; 3 letter abbreviation

J

Julian day; the number of days since 31 December 4713 BC

Time Format

AM or PM

Meridian indicator

A.M. or P.M.

Meridian indicator with periods

HH or HH12 or HH24

Hour of day or hour(1-12) or hour(0-23)

MI

Minute (0-59)

SS

Second (0-59)

SSSSS

Seconds past midnight (0-86399)

Date Display Suffixes

TH

Ordinal number (i.e. DDTH for 5TH)

SP

Spelled-out number (i.e. DDSP for FIVE)

SPTH or THSP

Spelled-out ordinal numbers (i.e. DDSPTH for FIFTH)

Other Date Formatting

/ , .

Punctuation is reproduced in the result

"of the"

Quoted string is reproduced in the result