timestamp

timestamp types in the datetime domain

timestamp

timestamp types in the datetime domain

27 types

Common Log Format (Apache/Nginx)clf

TIMESTAMPTZ15/Jan/2024:14:30:00 +0000

C ctime / asctime Formatctime

TIMESTAMPMon Jan 15 14:30:00 2024

DMY Hour-Minute Datetimedmy_hm

TIMESTAMP15/01/2024 10:30

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

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

MDY 12-Hour Datetimemdy_12h

TIMESTAMP01/15/2024 10:30 AM

MDY 24-Hour Datetimemdy_24h

TIMESTAMP01/15/2024 10:30:00

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

Type Registry

Common Log Format (Apache/Nginx)C ctime / asctime Format DMY Hour-Minute Datetime European Dot Timestamp (DMY 24h)Dot YMD Timestamp (24h)Unix Epoch Nanoseconds ISO 8601 ISO 8601 Compact ISO 8601 with Microseconds and Offset ISO 8601 with Microseconds ISO 8601 with Milliseconds and Offset ISO 8601 with Milliseconds ISO 8601 with Timezone Offset ISO Datetime with Microseconds (no timezone)ISO with Space Separator and Z MDY 12-Hour Datetime MDY 24-Hour Datetime PostgreSQL Short Offset RFC 2822 RFC 2822 with Ordinal Indicators RFC 3339 (Space Separator)Slash YMD Timestamp (24h)SQL Timestamp with Microseconds SQL Timestamp with Microseconds and Offset SQL Timestamp with Milliseconds SQL Standard BSD Syslog (RFC 3164)

Meridian © 2026