Date Formatting Guide

Time

Unit

Token

Description

Expected Output

Example

AM/PM

Uppercase meridiem

AM PM

Meridiem

am pm

Hour

Hour in 24-hour time, no padding

0 1 ... 22 23

Hour in 24-hour time, padded to 2

00 01 ... 22 23

Hour in 12-hour time, no padding

1 2 ... 11 12

Hour in 12-hour time, padded to 2

01 02 ... 11 12

1-based hour in 24-hour time, no padding

1 2 ... 23 24

1-based hour in 24-hour time, padded to 2

01 02 ... 23 24

Minute

Minute, no padding

0 1 ... 58 59

Minute, padded to 2

00 01 ... 58 59

Second

Second, no padding Notion only displays time to the minute

0 1 ... 58 59

Second, padded to 2 Notion only displays time to the minute

00 01 ... 58 59

Fractional Second

Fractional seconds, between 0 and 9 Notion only displays time to the minute

0 1 ... 8 9

Fractional seconds, between 0 and 99, padded to 2 Notion only displays time to the minute

00 01 ... 98 99

SSS

Fractional seconds, between 0 and 999, padded to 3 Notion only displays time to the minute

000 001 ... 998 999

000

Localised Time

Localised 12-hour time (no padding), uppercase meridiem

8:30 PM

101445385600000

Localised Time with Seconds

LTS

Localised 12-hour time with seconds (no padding), uppercase meridiem Notion only displays time to the minute

8:30:25 PM

1014453856000000

Days

Unit

Token

Description

Expected Output

Example

Day of Month

Day of month, no padding

1 2 ... 30 31

Day of month, with ordinal suffix

1st 2nd ... 30th 31st

294th

Day of month, padded to 2

01 02 ... 30 31

Day of Year

DDD

Day of year, no padding

1 2 ... 364 365

294

DDDo

Day of year, with ordinal suffix

1st 2nd ... 364th 365th

DDDD

Day of year, padded to 3

001 002 ... 364 365

0294

Day of Week

Zero-based day of week, no padding

0 1 ... 5 6

Zero-based day of week, with ordinal suffix

0th 1st ... 5th 6th

21st

Localised day of week name, 2-letter abbreviation

Su Mo ... Fr Sa

ddd

Localised day of week name, 3-letter abbreviation

Sun Mon ... Fri Sat

021

dddd

Localised day of week name, unabbreviated

Sunday Monday ... Friday Saturday

Wednesday

Day of Week (ISO)

ISO day of week, no padding

1 2 ... 6 7

Wed

Day of Week (Locale)

Localised zero-based day of week, no padding

0 1 ... 5 6

Weeks

Unit

Token

Description

Expected Output

Example

Week of Year

Week of year, no padding

1 2 ... 52 53

Week of year, with ordinal suffix

1st 2nd ... 52nd 53rd

43rd

Week of year, padded to 2

01 02 ... 52 53

Week of Year (ISO)

ISO week of year, no padding

1 2 ... 52 53

ISO week of year, with ordinal suffix

1st 2nd ... 52nd 53rd

ISO week of year, padded to 2

01 02 ... 52 53

Months

Unit

Token

Description

Expected Output

Example

Month

Month, no padding

1 2 ... 11 12

Month, with ordinal suffix

1st 2nd ... 11th 12th

10th

Month, padded to 2

01 02 ... 11 12

MMM

Localised month name, 3-letter abbreviation

Jan Feb ... Nov Dec

Oct

MMMM

Localised month name, unabbreviated

January February ... November December

October

Quarters

Unit

Token

Description

Expected Output

Example

Quarter

Quarter, no padding

1 2 3 4

Quarter, with ordinal suffix

1st 2nd 3rd 4th

4th

Quarter, padded to 2

01 02 03 04

Years

Unit

Token

Description

Expected Output

Example

Year

ISO year

1970 1971 ... 9999 +10000 +10001

2015

Year, 2 digits

70 71 ... 29 30

YYYY

Year, 4 digits

1970 1971 ... 2029 2030

YYYYYY

Expanded year

001970 -001971 ... +001907 +001971

002015

Week Year

Week year, 2 digits

70 71 ... 29 30

gggg

Week year, 4 digits

1970 1971 ... 2029 2030

Week Year (ISO)

ISO week year, 2 digits

70 71 ... 29 30

GGGG

ISO week year, 4 digits

1970 1971 ... 2029 2030

Anno Domini

Timestamp

Unit

Token

Description

Expected Output

Example

Unix Timestamp

Unix timestamp

1360013296

Unix Millisecond Timestamp

Unix millisecond timestamp

1360013296123

+00

Time Zone

Unit

Token

Description

Expected Output

Example

Time Zone

Time zone, short offset

-07:00 -06:00 ... +06:00 +07:00

Time zone, techie offset

-0700 -0600 ... +0600 +0700

ZZZ

Time zone, unabbreviated named offset

+0500

Date & Time

Unit

Token

Description

Expected Output

Example

Localised Month numeral, day of month, year

Localised month (padded to 2), day of month (padded to 2), year (4 digits)

09/04/1986

Localised month (no padding), day of month (no padding), year (4-digits)

9/4/1986

Localised Month name, day of month, year

Localised month name (unabbreviated), day of month (no padding), year (4-digits)

September 4, 1986

Localised month name (3-letter abbreviation), day of month (no padding), year (4-digits)

Sep 4, 1986

Localised Month name, day of month, year, time

LLL

Localised month name (unabbreviated), day of month (no padding), year (4-digits), 12-hour time (no padding), uppercase meridiem

September 4, 1986 8:30 PM

Oct

lll

Localised month name (3-letter abbreviation), day of month (no padding), year (4-digits), 12-hour time (no padding), uppercase meridiem

Sep 4, 1986 8:30 PM

Localised Month name, day of month, day of week, year, time

LLLL

Localised day of week name (unabbreviated), month name (unabbreviated), day of month (no padding), year (4-digits), time (no padding)

Thursday, September 4, 1986 8:30 PM

October

llll

Localised day of week name (3-letter abbreviation), month name (3-letter abbreviation), day of month (no padding), year (4-digits), time (no padding)

Thu, Sep 4, 1986 8:30 PM

Other

Unit

Token

Description

Expected Output

Example

Escaped Characters

[Text Here]

Escaped characters (between square brackets)

Text here

Great Scott!

No description

Unit

Token

Description

Expected Output

Example

By Ben · Latest · Email Website Reddit Twitter Find something useful? Please consider buying me a coffee. Cheers!