Tokens for date/time formatting

Modified on Thu, 30 May at 10:38 AM

Use date/time formatting tokens to change the format of date/time data. For example, you can convert a timestamp to a quarter of the year or day of the week. The following tables present the tokens supported for changes in formatting.

Year, month, and day tokens

Token	Output	Description
`YY`	`70 71 ... 29 30`	2 digit year
`YYYY`	`1970 1971 ... 2029 2030`	4 digit year
`Y`	`1970 1971 ... 9999 +10000 +10001`	Year with any number of digits and sign
`Q`	`1 2 3 4`	Quarter of year
`Qo`	`1st 2nd 3rd 4th`	Quarter of year with ordinal
`M`	`1 2 ... 11 12`	Month number
`Mo`	`1st 2nd ... 11th 12th`	Month with ordinal
`MM`	`01 02 ... 11 12`	Month number with leading zero
`MMM`	`Jan Feb ... Nov Dec`	Month abbreviation
`MMMM`	`January February ... November December`	Month name
`D`	`1 2 ... 30 31`	Day of month
`Do`	`1st 2nd ... 30th 31st`	Day of month with ordinal
`DD`	`01 02 ... 30 31`	Day of month with leading zero
`DDD`	`1 2 ... 364 365`	Day of year
`DDDo`	`1st 2nd ... 364th 365th`	Day of year with ordinal
`DDDD`	`001 002 ... 364 365`	Day of year with leading zero

Week year, week, and weekday tokens

Token	Output	Description
`d`	`0 1 ... 5 6`	Day of week
`do`	`0th 1st ... 5th 6th`	Day of week with ordinal
`dd`	`Su Mo ... Fr Sa`	Day abbreviation
`ddd`	`Sun Mon ... Fri Sat`	Day abbreviation
`dddd`	`Sunday Monday ... Friday Saturday`	Day name
`E`	`1 2 ... 6 7`	Day of week (ISO)
`w`	`1 2 ... 52 53`	Week of year
`wo`	`1st 2nd ... 52nd 53rd`	Week of year with ordinal
`ww`	`01 02 ... 52 53`	Week of year with leading zero
`W`	`1 2 ... 52 53`	Week of year (ISO)
`Wo`	`1st 2nd ... 52nd 53rd`	Week of year with ordinal (ISO)
`WW`	`01 02 ... 52 53`	Week of year with leading zero (ISO)
`gg`	`70 71 ... 29 30`	Week year
`gggg`	`1970 1971 ... 2029 2030`	Week year
`GG`	`70 71 ... 29 30`	Week year (ISO
`GGGG`	`1970 1971 ... 2029 2030`	Week year (ISO)

Hour, minute, second, millisecond, and offset tokens

Token	Output	Description
`H`	`0 1 ... 22 23`	24 hour time
`HH`	`00 01 ... 22 23`	24 hour time with leading zero
`h`	`1 2 ... 11 12`	12 hour time
`hh`	`01 02 ... 11 12`	12 hour time with leading zero
`k`	`1 2 ... 23 24`	24 hour time
`kk`	`01 02 ... 23 24`	24 hour time with leading zero
`A`	`AM PM`	Post or ante meridiem (upper case)
`a`	`am pm`	Post or ante meridiem (lower case)
`m`	`0 1 ... 58 59`	Minutes
`mm`	`00 01 ... 58 59`	Minutes with leading zero
`s`	`0 1 ... 58 59`	Seconds
`ss`	`00 01 ... 58 59`	Seconds with leading zero
`S`	`0 1 ... 8 9`	Fractional seconds
`SS`	`00 01 ... 98 99`	Fractional seconds with leading zero
`SSS`	`000 001 ... 998 999`	Fractional seconds with two leading zeros
`SSSS ... SSSSSSSSS`	`000[0..] 001[0..] ... 998[0..] 999[0..]`	Fractional seconds
`Z`	`-07:00 -06:00 ... +06:00 +07:00`	Time zone
`ZZ`	`-0700 -0600 ... +0600 +0700`	Time zone
`X`	`1360013296`	Unix Timestamp
`x`	`1360013296123`	Unix Millisecond Timestamp