Time formatting for visualizations
You can format time value in visualizations using the following syntax, and you can string expressions together to create custom formats.
Time
| Expression | Description |
|---|---|
| %L | Milliseconds as a decimal number (000 to 999) |
| %S | Second as a two-digit number (00 to 59) |
| %M | Minute as a two-digit number (00 to 59) |
| %H | Hour as a decimal number (24-hour clock) (00 to 23) |
| %I | Hour as a decimal number (12-hour clock) (01 to 12) |
| %p | Either AM or PM |
Date
| Expression | Description |
|---|---|
| %j | Day of the year as a decimal number (001 to 366) |
| %d | Zero-padded day of the month (01 to 31) |
| %e |
Space-padded day of the month (equivalent to %_ d) (1 to 31) |
| %A | Full weekday name, i.e. Monday, Tuesday, Wednesday |
| %a | Abbreviated weekday name (3-letter), i.e. Mon, Tue, Wed |
| %w | Weekday as a decimal number (Sunday as the first day of the week) (0 to 6) |
Week
| Expression | Description |
|---|---|
| %U | Week number of the year (Sunday as the first day of the week) as a two-digit number, i.e. 00 to 53 Note : %U uses the ISO week date standard offset by one day. |
| %W |
Week number of the year (Monday as the first day of the week) as a two-digit number, i.e. 00 to 53 Note: %W uses the ISO week date standard. |
Month
| Expression | Description |
|---|---|
| %m | Two-digit month (01 to 12) (1-12 format not currently available) |
| %b | Abbreviated month name (Jan, Feb, Mar...) |
| %B | Full month name (January, February, March...) |
Year
| Expression | Description |
|---|---|
| %y | Two-digit year (00 to 99) |
| %Y | Four-digit year (2000, 2001, 2002...) |
Combination
| %X | Full time, of the form "%H:%M:%S" (23:56:12) |
| %x | Full date, of the form "%m/%d/%Y" (01/27/2023) |
| %c | Datetime format with the following: "%a %b %e %H:%M:%S %Y" (Mon Jan 1 23:56:04 2023) |