Fork me on GitHub

List 55: Date format

Last updated in issue 62
Value Description Notes Issue number Modified in Issue
00 YYYYMMDD Common Era year, month and day (default for most dates) 0 41
01 YYYYMM Year and month 0
02 YYYYWW Year and week number 0
03 YYYYQ Year and quarter (Q = 1, 2, 3, 4, with 1 = Jan to Mar) 0
04 YYYYS Year and season (S = 1, 2, 3, 4, with 1 = ‘Spring’) 1
05 YYYY Year (default for some dates) 1
06 YYYYMMDDYYYYMMDD Spread of exact dates 1
07 YYYYMMYYYYMM Spread of months 1
08 YYYYWWYYYYWW Spread of week numbers 1
09 YYYYQYYYYQ Spread of quarters 1
10 YYYYSYYYYS Spread of seasons 1
11 YYYYYYYY Spread of years 1
12 Text string For complex, approximate or uncertain dates, or dates BCE. Suggested maximum length 100 characters 1 62
13 YYYYMMDDThhmm Exact time. Use ONLY when exact times with hour/minute precision are relevant. By default, time is local. Alternatively, the time may be suffixed with an optional ‘Z’ for UTC times, or with ‘+’ or ‘-’ and an hhmm timezone offset from UTC. Times without a timezone are ‘rolling’ local times, times qualified with a timezone (using Z, + or -) specify a particular instant in time 17 18
14 YYYYMMDDThhmmss Exact time. Use ONLY when exact times with second precision are relevant. By default, time is local. Alternatively, the time may be suffixed with an optional ‘Z’ for UTC times, or with ‘+’ or ‘-’ and an hhmm timezone offset from UTC. Times without a timezone are ‘rolling’ local times, times qualified with a timezone (using Z, + or -) specify a particular instant in time 17 18
20 YYYYMMDD (H) Year month day (Hijri calendar) 13
21 YYYYMM (H) Year and month (Hijri calendar) 13
25 YYYY (H) Year (Hijri calendar) 13
32 Text string (H) For complex, approximate or uncertain dates (Hijri calendar), text would usually be in Arabic script. Suggested maximum length 100 characters 13
Back to Codelists