Tokens for date/time parsing

Date/time parsing tokens are special combinations of letters you can use to read and extract date/time data. The following tables list the tokens you can use to parse data in your functions:

Year, month, and day tokens

Input

Example

Description

YYYY 

2014

4 or 2 digit year

YY

14

2 digit year

Y

-25

Year with any number of digits and sign

Q

1..4

Quarter of year

[Note] Note

Sets month to first month in quarter

M MM

1..12

Month number

MMM MMMM

Jan..December

Month name

D DD

1..31

Day of month

Do

1st..31st

Day of month with ordinal numbers

DDD DDDD

1..365

Day of year

X

1410715640.579

Unix timestamp

x

1410715640579

Unix ms timestamp

Week year, week, and weekday tokens

Input

Example

Description

ddd dddd

Mon...Sunday

Day name

GGGG

2014

ISO 4 digit week year

GG

14

ISO 2 digit week year

W WW

1..53

ISO week of year

E

1..7

ISO day of week

Hour, minute, second, millisecond, and offset tokens

Input

Example

Description

H HH

0..23

Hours (24 hour time)

h hh

1..12

Hours (12 hour time used with a A)

k kk

1..24

Hours (24 hour time from 1 to 24)

a A

am pm

Post or ante meridiem (Note the one character a p are also considered valid)

m mm

0..59

Minutes

s ss

0..59

Seconds

S SS SSS

0..999

Fractional seconds

Z ZZ

+12:00

Offset from UTC as +-HH:mm+-HHmm, or Z