For a date column, an individual display format can be set. Below is a list of specifiers and usage examples.

YY — Two-digit year — 18

YYYY — Four-digit year — 2018

M — Month, starting from 1 — 1–12

MM — Month, 2 digits — 01–12

MMM — Abbreviated month name — Jan–Dec

MMMM — Full month name — January–December

D — Day of month — 1–31

DD — Day of month, 2 digits — 01–31

d — Day of week, where Sunday is 0 — 0–6

dd — Short (two-letter) day of week name — Su–Sa

ddd — Abbreviated day of week name — Sun–Sat

dddd — Full day of week name — Sunday–Saturday

H — Hour (24-hour format) — 0–23

HH — Hour (24-hour format), 2 digits — 00–23

h — Hour (12-hour format) — 1–12

hh — Hour (12-hour format), 2 digits — 01–12

m — Minute — 0–59

mm — Minute, 2 digits — 00–59

s — Second — 0–59

ss — Second, 2 digits — 00–59

SSS — Millisecond, 3 digits — 000–999

Z — Offset from UTC, ±HH:mm — +05:00

ZZ — Offset from UTC, ±HHmm — +0500

A — AM/PM — AM PM

a — am/pm — am pm

YYYY-MM-DD HH:mm:ss Z — 2023-04-15 12:30:15 +05:00

YYYY-MMM-DD — 2023-Apr-15

MMMM YYYY — April 2023

ddd, MMM DD, YYYY — Sun, Apr 15, 2023

dd MMM HH:mm — Sun Apr 12:30

📌 Next step: Data Types →

📌 Also useful: Columns