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

%y

Last two decimal digits of the year.

%Y

Year as a decimal number.

%b

Abbreviated month name.

%B

Full month name.

%m

Month as a decimal number (January is 01), prefixed with 0 if needed.

%d

Day of the month as a decimal number, prefixed with 0 if needed.

%e

Day of the month as a decimal number, prefixed with a space if needed.

%D

Equivalent to %m/%d/%y.

%F

Equivalent to %Y-%m-%d.

{RECEIVED|%B %e, %Y} converts to April 1, 2023
{RECEIVED|%F} converts to 2023-04-01

Weekday Format

Spec Description

%a

Abbreviated weekday name.

%A

Full weekday name.

%u

Weekday as a decimal number (1–7), where Monday is 1.

%w

Weekday as a decimal number (0–6), where Sunday is 0.

{RECEIVED|%A} converts to Saturday

Time Format

Spec Description

%H

Hour (24-hour clock) as a decimal number, prefixed with 0 if needed.

%I

Hour (12-hour clock) as a decimal number, prefixed with 0 if needed.

%p

Locale equivalent of AM/PM for a 12-hour clock.

%M

Minutes as a decimal number, prefixed with 0 if needed.

%S

Seconds as a decimal number (prefixed with 0 if needed), followed by the fractional part when the timestamp has it.

%T

Equivalent to %H:%M:%S.

{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

%Z

Time zone abbreviation.

%z

Offset from UTC, for example -0430 (4 hours 30 minutes behind UTC). +0000 if the offset is zero.

%Ez

Same as %z with a colon between hours and minutes (for example -04:30).

Miscellaneous

Spec Description

%Q

Microseconds since the UNIX epoch (1 January 1970 00:00:00 UTC).

%j

Day of the year as a decimal number (1 January is 001), left-padded with 0 to three digits.

%U

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.

%W

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.

%x

Locale date representation.

%c

Locale date and time (rounded to seconds).

{RECEIVED|%Q} converts to 1680366001000000
{RECEIVED|%j} converts to 091