Explore more
Functions
Tokens for date/time parsing
3min
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 a year 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