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 |
|---|---|---|
|
| 4 or 2 digit year |
|
| 2 digit year |
|
| Year with any number of digits and sign |
|
| Quarter of year NoteSets month to first month in quarter |
|
| Month number |
|
| Month name |
|
| Day of month |
|
| Day of month with ordinal numbers |
|
| Day of year |
|
| Unix timestamp |
|
| Unix ms timestamp |
Week year, week, and weekday tokens
Input | Example | Description |
|---|---|---|
|
| Day name |
|
| ISO 4 digit week year |
|
| ISO 2 digit week year |
|
| ISO week of year |
|
| ISO day of week |
Hour, minute, second, millisecond, and offset tokens
Input | Example | Description |
|---|---|---|
|
| Hours (24 hour time) |
|
| Hours (12 hour time used with |
|
| Hours (24 hour time from 1 to 24) |
|
| Post or ante meridiem (Note the one character |
|
| Minutes |
|
| Seconds |
|
| Fractional seconds |
|
| Offset from UTC as |