Format masks

 

The table below lists the format masks that can be used for message state fields. For example, a timestamp message state may have a format of YYYYMMDD HH24:MI:SS.MS

Type

Pattern

Meaning

Timestamp

H

hour of day (01-12)

 

HH12

hour of day (01-12)

 

HH24

hour of day (00-23)

 

MI

minute (00-59)

 

SS

second (00-59)

 

MS

millisecond (000-999)

 

US

microsecond (000000-999999)

 

SSSS

seconds past midnight (0-86399)

 

AM, am, PM or pm

meridiem indicator (without periods)

 

A.M., a.m., P.M. or p.m.

meridiem indicator (with periods)

 

Y,YYY

year (4 or more digits) with comma

 

YYYY

year (4 or more digits)

 

YYY

last 3 digits of year

 

YY

last 2 digits of year

 

Y

last digit of year

 

IYYY

ISO 8601 week-numbering year (4 or more digits)

 

IYY

last 3 digits of ISO 8601 week-numbering year

 

IY

last 2 digits of ISO 8601 week-numbering year

 

I

last digit of ISO 8601 week-numbering year

 

MONTH

full upper case month name (blank-padded to 9 chars)

 

Month

full capitalized month name (blank-padded to 9 chars)

 

month

full lower case month name (blank-padded to 9 chars)

 

MON

abbreviated upper case month name (3 chars in English, localized lengths vary)

 

Mon

abbreviated capitalized month name (3 chars in English, localized lengths vary)

 

mon

abbreviated lower case month name (3 chars in English, localized lengths vary)

 

MM

month number (01-12)

 

DAY

full upper case day name (blank-padded to 9 chars)

 

Day

full capitalized day name (blank-padded to 9 chars)

 

day

full lower case day name (blank-padded to 9 chars)

 

DY

abbreviated upper case day name (3 chars in English, localized lengths vary)

 

Dy

abbreviated capitalized day name (3 chars in English, localized lengths vary)

 

dy

abbreviated lower case day name (3 chars in English, localized lengths vary)

 

DDD

day of year (001-366)

 

IDDD

day of ISO 8601 week-numbering year (001-371; day 1 of the year is Monday of the first ISO week)

 

DD

day of month (01-31)

 

D

day of the week, Sunday (1) to Saturday insert_rowcreate(7)

 

ID

ISO 8601 day of the week, Monday (1) to Sunday (7)

 

W

week of month (1-5) (the first week starts on the first day of the month)

 

WW

week number of year (1-53) (the first week starts on the first day of the year)

 

IW

week number of ISO 8601 week-numbering year (01-53; the first Thursday of the year is in week 1)

 

CC

century (2 digits) (the twenty-first century starts on 2001-01-01)

 

J

Julian Day (days since November 24, 4714 BC at midnight)

 

TZ

uppercase time-zone name

 

tz

lowercase time-zone name

Number

9

value with the specified number of digits

 

D

expected position of decimal point

 

S

expected position of sign

 

V

shift value by number of digits

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk