Skip to content

Datetime

Type Registry

datetime

Dates, times, timestamps, durations, and timezone offsets

46 types

component

6
Calendar Year year
SMALLINT 2024
Century (Roman Numeral) century
VARCHAR XIX
Day of Month day_of_month
TINYINT 1
Day of Week Name day_of_week
VARCHAR Monday
Full Month Name month_name
VARCHAR January
Periodicity periodicity
VARCHAR Daily

date

17
Abbreviated Month Date abbreviated_month
DATE Jan 15, 2024
Compact Date (DDMMYYYY) compact_dmy
DATE 15012024
Compact Date (MMDDYYYY) compact_mdy
DATE 01152024
Compact Date (YYYYMMDD) compact_ymd
DATE 20240115
European Date (dot-separated) eu_dot
DATE 15.01.2024
European Date (slash-separated) eu_slash
DATE 15/01/2024
Full Weekday with Abbreviated Month weekday_abbreviated_month
DATE Monday, 15 Jan 2024
Full Weekday with Full Month Name weekday_full_month
DATE Monday, 15 January 2024
ISO Date iso
DATE 2024-01-15
ISO Week Date iso_week
DATE 2024-W03
Julian Date julian
DATE 24-015
Long Date with Full Month Name long_full_month
DATE January 15, 2024
Ordinal Date ordinal
DATE 2024-015
Short Date (Day-Month-Year, 2-digit year) short_dmy
DATE 15-01-24
Short Date (Month-Day-Year, 2-digit year) short_mdy
DATE 01-15-24
Short Date (Year-Month-Day, 2-digit year) short_ymd
DATE 24-01-15
US Date (slash-separated) us_slash
DATE 01/15/2024

duration

1
ISO 8601 Duration iso_8601
INTERVAL PT30M

epoch

3
Unix Timestamp (microseconds) unix_microseconds
TIMESTAMP 1705312200000000
Unix Timestamp (milliseconds) unix_milliseconds
TIMESTAMP 1705312200000
Unix Timestamp (seconds) unix_seconds
TIMESTAMP 1705312200

offset

2
IANA Timezone Name iana
VARCHAR America/New_York
UTC Offset utc
VARCHAR UTC +05:00

time

5
12-Hour Time (HH:MM AM/PM) hm_12h
TIME 10:30 AM
12-Hour Time with AM/PM hms_12h
TIME 10:30:00 AM
24-Hour Time (HH:MM:SS) hms_24h
TIME 10:30:00
24-Hour Time (HH:MM) hm_24h
TIME 10:30
ISO Time with Microseconds iso
TIME 10:30:00.123456

timestamp

12
American Datetime american
TIMESTAMP 01/15/2024 10:30 AM
American Datetime (24-hour) american_24h
TIMESTAMP 01/15/2024 10:30:00
European Datetime european
TIMESTAMP 15/01/2024 10:30
ISO 8601 iso_8601
TIMESTAMP 2024-01-15T10:30:00Z
ISO 8601 Compact iso_8601_compact
TIMESTAMP 20240115T103000
ISO 8601 with Microseconds iso_8601_microseconds
TIMESTAMP 2024-01-15T10:30:00.1234…
ISO 8601 with Timezone Offset iso_8601_offset
TIMESTAMPTZ 2024-01-15T10:30:00+05:0…
ISO Datetime with Microseconds (no timezone) iso_microseconds
TIMESTAMP 2024-01-15T10:30:00.1234…
RFC 2822 rfc_2822
TIMESTAMPTZ Tue, 15 Jan 2024 10:30:0…
RFC 2822 with Ordinal Indicators rfc_2822_ordinal
TIMESTAMPTZ 15th Jan 2024 10:30:00 +…
RFC 3339 (Space Separator) rfc_3339
TIMESTAMPTZ 2024-01-15 10:30:00+00:0…
SQL Standard sql_standard
TIMESTAMP 2024-01-15 10:30:00