Commonly Used Elements of the DATE Format Mask

Table 5.4. Commonly Used Elements of the DATE Format Mask

Format

Description

YYYY

Four-digit year.

YEAR

Year, spelled out.

RR

Two-digit year, based on century. If two-digit year is between 50 and 99, then it’s the previous century; if the year is between 00 and 49, it’s the current century.

MM

Two-digit month.

MON

Three-letter abbreviation of the month, in uppercase letters.

MONTH

Month, spelled out, in uppercase letters and padded with blanks.

Month

Month, spelled with, first letter uppercase and padded with blanks to a length of nine characters.

DD

Numeric day (1–31).

DAY

Day of the week, spelled out, in uppercase letters and padded with blanks to a length of nine characters.

DY

Three-letter abbreviation of the day of the week, in uppercase letters.

D

Day of the week number (1–7), where Sunday is day 1, Monday is day 2, and so forth.

DDD

Day of the year (1–366).

DL

Day long format; the equivalent format mask is fmDay, Month DD, YYYY.

HH or HH12

Hours (0–12).

HH24

Hours in military format (0–23).

MI

Minutes (0–59).

SS

Seconds (0–59).

SSSSS

Seconds past midnight (0–86399).

AM or PM

Meridian indicator.

TS

Short time format; the equivalent format mask is HH:MI:SS AM.

WW

Week of the year (1–53).

W

Week of the month (1–5).

Q

Quarter of the year.