How it works
Enter a format using date and time tokens. Hive replaces each token with the corresponding value from the event start time.
You can also include plain text by wrapping it in square brackets [].
Examples:
MMMM D, YYYY → January 15, 2026
ddd, MMM D [at] h:mma → Wed, Jan 15 at 7:30pm
DD/MM/YYYY → 15/01/2026
Available Format Tokens
Use these tokens in your format string. Note that tokens are case-sensitive!
Token | Description | Example |
M | Month number | 1, 2, ... 12 |
MM | Month number (zero-padded) | 01, 02, ... 12 |
MMM | Month name (short) | Jan, Feb, ... Dec |
MMMM | Month name (full) | January, February, ... December |
D | Day of month | 1, 2, ... 31 |
DD | Day of month (zero-padded) | 01, 02, ... 31 |
Do | Day of month with ordinal | 1st, 2nd, ... 31st |
d | Day of week (number) | 0, 1, ... 6 |
dd | Day of week (min name) | Su, Mo, ... Sa |
ddd | Day of week (short) | Sun, Mon, ... Sat |
dddd | Day of week (full) | Sunday, Monday, ... Saturday |
YY | Year (two digits) | 24, 25, 26 |
YYYY | Year (four digits) | 2024, 2025, 2026 |
H | Hour (24-hour) | 0, 1, ... 23 |
HH | Hour (24-hour, zero-padded) | 00, 01, ... 23 |
h | Hour (12-hour) | 1, 2, ... 12 |
hh | Hour (12-hour, zero-padded) | 01, 02, ... 12 |
m | Minute | 0, 1, ... 59 |
mm | Minute (zero-padded) | 00, 01, ... 59 |
s | Second | 0, 1, ... 59 |
ss | Second (zero-padded) | 00, 01, ... 59 |
a | AM/PM (lowercase) | am, pm |
A | AM/PM (uppercase) | AM, PM |
z | Timezone abbreviation | EST, PST, GMT |
Adding Your Own Text
Wrap any text you want displayed exactly as typed in square brackets []. Everything inside the brackets will be displayed as-is.
Examples:
Format: MMMM D, YYYY [at] h:mma
Result: January 15, 2026 at 7:30pm
(The word "at" appears because it was in brackets)
Format: dddd[,] MMMM Do
Result: Wednesday, January 15th
(The comma appears because it was in brackets)
Format: [Tonight! At] h:mma
Result: Tonight! At 7:30pm
Common Format Examples
Short date: M/D/YYYY → 1/15/2026
Long date: dddd, MMMM Do, YYYY → Wednesday, January 15th, 2026
With time and timezone: ddd MMM D [at] h:mma z → Wed Jan 15 at 7:30pm EST
24-hour time: YYYY-MM-DD HH:mm → 2026-01-15 19:30
Casual format: ddd, MMM D → Wed, Jan 15
International: DD/MM/YYYY → 15/01/2026
Tips:
Tokens are case-sensitive (MM is different from mm)
Use brackets [] for any text you want to appear literally
You can combine any tokens together to create your own format