TIMESTAMP Types

Stores a specified date and time. Represents values comprising of fields year, month, day, hour, minute, and second. The timestamp represents an absolute point in time.

TIMESTAMP does not take time zone into account. TIMESTAMP WITH TIME ZONE does take time zone into account.

Precision

All timestamps will have a precision of 6, meaning values can include up to microseconds.

Timezones

TIMESTAMP WITH TIME ZONE values will always be evaluated using the UTC time zone.

Syntax

TIMESTAMP
TIMESTAMP WITH TIME ZONE

Timestamp limits

The minimum and maximum supported values for timestamps vary depending on the target execution environment.

Spark-based engine: Supports an extended range of historical and future dates.
Vertica: May have more restrictive bounds depending on the specific data type and storage configuration.

For literals across all environments, the standard lower limit is:

0001-01-01 00:00:00

Note: For specific boundary values, consult the technical specifications for your active data processing layer.

Literals

> SELECT TIMESTAMP '2025-07-24 12:34:56'
2025-07-24 12:34:56

> SELECT TIMESTAMP WITH TIME ZONE '2025-07-24 12:34:56 EST';
2025-07-24 17:34:56 UTC