MeridianMERIDIAN
Type Registry

timestamp

timestamp types in the datetime domain

27 types
American Datetimeamerican
TIMESTAMP01/15/2024 10:30 AM
American Datetime (24-hour)american_24h
TIMESTAMP01/15/2024 10:30:00
Common Log Format (Apache/Nginx)clf
TIMESTAMPTZ15/Jan/2024:14:30:00 +0000
C ctime / asctime Formatctime
TIMESTAMPMon Jan 15 14:30:00 2024
European Dot Timestamp (DMY 24h)dot_dmy_24h
TIMESTAMP15.01.2024 14:30:00
Dot YMD Timestamp (24h)dot_ymd_24h
TIMESTAMP2024.01.15 14:30:00
Unix Epoch Nanosecondsepoch_nanoseconds
TIMESTAMP1705325400000000000
European Datetimeeuropean
TIMESTAMP15/01/2024 10:30
ISO 8601iso_8601
TIMESTAMP2024-01-15T10:30:00Z
ISO 8601 Compactiso_8601_compact
TIMESTAMP20240115T103000
ISO 8601 with Microseconds and Offsetiso_8601_micros_offset
TIMESTAMPTZ2024-01-15T14:30:00.123456+0…
ISO 8601 with Microsecondsiso_8601_microseconds
TIMESTAMP2024-01-15T10:30:00.123456Z
ISO 8601 with Milliseconds and Offsetiso_8601_millis_offset
TIMESTAMPTZ2024-01-15T14:30:00.123+05:3…
ISO 8601 with Millisecondsiso_8601_milliseconds
TIMESTAMP2024-01-15T14:30:00.123Z
ISO 8601 with Timezone Offsetiso_8601_offset
TIMESTAMPTZ2024-01-15T10:30:00+05:00
ISO Datetime with Microseconds (no timezone)iso_microseconds
TIMESTAMP2024-01-15T10:30:00.123456
ISO with Space Separator and Ziso_space_zulu
TIMESTAMP2024-01-15 14:30:00Z
PostgreSQL Short Offsetpg_short_offset
TIMESTAMPTZ2024-01-15 14:30:00.123456-0…
RFC 2822rfc_2822
TIMESTAMPTZTue, 15 Jan 2024 10:30:00 GM…
RFC 2822 with Ordinal Indicatorsrfc_2822_ordinal
TIMESTAMPTZ15th Jan 2024 10:30:00 +0000
RFC 3339 (Space Separator)rfc_3339
TIMESTAMPTZ2024-01-15 10:30:00+00:00
Slash YMD Timestamp (24h)slash_ymd_24h
TIMESTAMP2024/01/15 14:30:00
SQL Timestamp with Microsecondssql_microseconds
TIMESTAMP2024-01-15 14:30:00.123456
SQL Timestamp with Microseconds and Offsetsql_microseconds_offset
TIMESTAMPTZ2024-01-15 14:30:00.123456+0…
SQL Timestamp with Millisecondssql_milliseconds
TIMESTAMP2024-01-15 14:30:00.123
SQL Standardsql_standard
TIMESTAMP2024-01-15 10:30:00
BSD Syslog (RFC 3164)syslog_bsd
VARCHARJan 15 14:30:00