ISO 8601 date format

The international standard for writing dates and times as text, such as 2024-01-15T10:00:00Z.

In more detail

Fields go from largest to smallest unit, so timestamps sort correctly as text. The trailing Z means Coordinated Universal Time, and RFC 3339 is the internet profile most software follows.

Examples

ISO 8601 times sort correctly as plain text, which is why SQLite and many log tools store them as YYYY-MM-DD HH:MM:SS strings.
'occurred_at': '2024-01-15T10:00:00Z'
date.today().isoformat()
2024-03-01: SQLite date columns in the SQL course are text in this layout, so sorting them as text gives date order.
Day-first dates such as 01/03/2024 sort wrongly and break SQLite date functions.

Related terms

Taught in

References

Certification courses