The returned timestamp is in the time zone for the session. The display format for timestamps in the output is determined by the timestamp output format that corresponds with the function (TIMESTAMP_OUTPUT_FORMAT, TIMESTAMP_LTZ_OUTPUT_FORMAT, TIMESTAMP_NTZ_OUTPUT_FORMAT, or TIMESTAMP_TZ_...
Snowflakeuses the word "wallclock" (I like that, but didn't make use of it) for the description of theirNO TIME ZONEtype: TIMESTAMP_NTZ internally stores “wallclock” time with a specified precision. All operations are performed without taking any time zone into account. PostgreSQLwiki als...
My read of Snowflake is that: TIMESTAMP_NTZbehaves like DuckDB'sTIMESTAMPin that the implicit time zone/calendar/civil time is UTC (they may say there is no TZ but without a calendar the binning operations are not defined) TIMESTAMP_LTZbehaves like Postgres'TIMESTAMP WITH TIME ZONEin that...
The display format for timestamps in the output is determined by the timestamp output format that corresponds with the function (TIMESTAMP_OUTPUT_FORMAT, TIMESTAMP_LTZ_OUTPUT_FORMAT, TIMESTAMP_NTZ_OUTPUT_FORMAT, or TIMESTAMP_TZ_OUTPUT_FORMAT). If the format of the input parameter is a string...
The following example casts values to TIMESTAMP_NTZ. The example shows the difference in behavior between using an integer and using a variant that contains an integer: SELECT 0::TIMESTAMP_NTZ, PARSE_JSON(0)::TIMESTAMP_NTZ, PARSE_JSON(0)::INT::TIMESTAMP_NTZ; +---+---+---+ | 0...