You are looking at the documentation for Firebolt’s redesigned date and timestamp types. These types were introduced in DB version 3.19.0 under the names
TIMESTAMPTZ, and synonyms
TIMESTAMPTZmade available in DB version 3.22.0.
If you worked with Firebolt before DB version 3.22.0, you might still be using the legacy date and timestamp types. Determine which types you are using by executing the query
SELECT EXTRACT(CENTURY FROM DATE '2023-03-16');. If this query returns a result, you are using the redesigned date and timestamp types and can continue with this documentation. If this query returns an error, you are using the legacy date and timestamp types and can find legacy documentation here, or instructions to use the new types here.
Returns the current local timestamp in the time zone specified in the session’s
The function can be called with or without parentheses:
The function takes the current Unix timestamp (in the UTC time zone), converts it to the time zone specified in the
time_zone setting, and returns it as a
TIMESTAMP value. Two simultaneous calls of the function can return different timestamps, due to time zone conversion.
The following example assumes that the current timestamp is
2023-03-03 14:42:31.123456 UTC. Observe how we return different
TIMESTAMP values with different time zone settings:
SET time_zone = 'Europe/Berlin'; SELECT LOCALTIMESTAMP; --> 2023-03-03 15:42:31.123456 SET time_zone = 'America/New_York'; SELECT LOCALTIMESTAMP; --> 2023-03-03 09:42:31.123456