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

Limits

The lower limit and upper limit will differ from engine to engine. Documentation:

Vertica Limits
Databricks Limits

For literals, the lower limit is the following:

0001-01-01 00:00:00

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