Date/Time Modifiers
These modifiers format RECEIVED (storage time zone) or RECEIVED_UTC (UTC).
They also apply to the _S and _MS variants.
In the examples below, {RECEIVED} is 2023-04-01T09:20:01.000000-0700.
Date Format
| Spec | Description |
|---|---|
|
Last two decimal digits of the year. |
|
Year as a decimal number. |
|
Abbreviated month name. |
|
Full month name. |
|
Month as a decimal number (January is 01), prefixed with 0 if needed. |
|
Day of the month as a decimal number, prefixed with 0 if needed. |
|
Day of the month as a decimal number, prefixed with a space if needed. |
|
Equivalent to |
|
Equivalent to |
{RECEIVED|%B %e, %Y} converts to April 1, 2023
{RECEIVED|%F} converts to 2023-04-01
Weekday Format
| Spec | Description |
|---|---|
|
Abbreviated weekday name. |
|
Full weekday name. |
|
Weekday as a decimal number (1–7), where Monday is 1. |
|
Weekday as a decimal number (0–6), where Sunday is 0. |
{RECEIVED|%A} converts to Saturday
Time Format
| Spec | Description |
|---|---|
|
Hour (24-hour clock) as a decimal number, prefixed with 0 if needed. |
|
Hour (12-hour clock) as a decimal number, prefixed with 0 if needed. |
|
Locale equivalent of AM/PM for a 12-hour clock. |
|
Minutes as a decimal number, prefixed with 0 if needed. |
|
Seconds as a decimal number (prefixed with 0 if needed), followed by the fractional part when the timestamp has it. |
|
Equivalent to |
{RECEIVED|%I:%M:%S %p} converts to 09:20:01.000000 AM
{RECEIVED_S|%I:%M:%S %p} converts to 09:20:01 AM
Timezone Format
| Spec | Description |
|---|---|
|
Time zone abbreviation. |
|
Offset from UTC, for example |
|
Same as |
Miscellaneous
| Spec | Description |
|---|---|
|
Microseconds since the UNIX epoch (1 January 1970 00:00:00 UTC). |
|
Day of the year as a decimal number (1 January is 001), left-padded with 0 to three digits. |
|
Week number of the year as a decimal number, prefixed with 0 if needed. The first Sunday of the year is the first day of week 01. Days of the same year before that are week 00. |
|
Week number of the year as a decimal number, prefixed with 0 if needed. The first Monday of the year is the first day of week 01. Days of the same year before that are week 00. |
|
Locale date representation. |
|
Locale date and time (rounded to seconds). |
{RECEIVED|%Q} converts to 1680366001000000
{RECEIVED|%j} converts to 091
Related Topics
-
Export to Files — daily file names