This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.
Syntax
PARSE FUNCTIONS This section contains parse functions that uses the specifier (format_string). The table below contains the supported patterns for the parse functions.| Specifier | Description |
|---|---|
| %a or %W | Abbreviated weekday name (Sun .. Sat) or Weekday name (Sunday .. Saturday) |
| %b or %M | Abbreviated month name (Jan .. Dec) or Month name (January .. December) |
| %d or %e | Day of the month, numeric (01 .. 31) or numeric (1 .. 31), this specifier does not support 0 as a month or day. |
| %c or %m | Month, numeric (1 .. 12), this specifier does not support 0 as a month. |
| %f | Fraction of second (6 digits for printing: 000000 .. 999000; 1 - 9 digits for parsing: 0 .. 999999999), timestamp is truncated to milliseconds |
| %H or %k | Hour (00 .. 23) |
| %h or %I | Hour (01 .. 12) |
| %j | Day of year (001 .. 366) |
| %i | Minutes, numeric (00 .. 59) |
| %S or %s | Seconds (00 .. 59) |
| %r | Time of day, 12-hour (equivalent to %h:%i:%s %p) |
| %T | Time of day, 24-hour (equivalent to %H:%i:%s) |
| %v | Week (01 .. 53), where Monday is the first day of the week and we can use %y or %x for year for using %x use 4 digits for year |
| %x | Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v |
| %Y | Year, numeric, four digits |
| %y | Year, numeric (two digits), when parsing, two-digit year format assumes range 1970 .. 2069, so “70” will result in year 1970 but “69” will produce 2069 |
| %% | A literal % character |