Date/Time Modifiers

%y

Last two digits of the year, 00–99.

%Y

Year, for example 2023.

%b

Abbreviated month name.

%B

Full month name.

%m

Month, 01–12.

%d

Day of the month, 01–31.

%e

Day of the month, 1–31, padded with a space.

%D

Equivalent to %m/%d/%y.

%F

Equivalent to %Y-%m-%d.

%a

Abbreviated weekday name.

%A

Full weekday name.

%u

Weekday, 1–7; Monday is 1.

%w

Weekday, 0–6; Sunday is 0.

%H

Hour, 00–23.

%I

Hour, 01–12.

%p

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

%M

Minute, 00–59.

%S

Second, 00–59, followed by the fraction when the timestamp has one.

%T

Equivalent to %H:%M:%S.

%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).

%Q

The time as a number of microseconds, for comparing times in SQL. With RECEIVED_UTC, it is the UNIX time: microseconds since 1 January 1970 00:00:00 UTC. With RECEIVED, it is the server time counted the same way, in whole seconds; it matches {FROM|%Q} and {TO|%Q} in report templates. Use %Q on its own, with no other text.

%j

Day of the year, 001–366.

%U

Week of the year, 00–53. Weeks start on Sunday; days before the first Sunday are week 00.

%W

Week of the year, 00–53. Weeks start on Monday; days before the first Monday are week 00.

%x

Locale date representation.

%c

Locale date and time (rounded to seconds).