snowflake.snowpark.functions.is_timestamp_ntz¶

snowflake.snowpark.functions.is_timestamp_ntz(col: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.20.0/src/snowflake/snowpark/functions.py#L4773-L4789)¶

Returns true if the specified VARIANT column contains a TIMESTAMP_NTZ value with no time zone.

Example:

CopyExpand

>>> from snowflake.snowpark.functions import to_variant, is_timestamp_ntz
>>> df = session.sql("select to_timestamp_ntz('2017-02-24 12:00:00.456') as timestamp_ntz1, "
...                  "to_timestamp_ltz('2017-02-24 13:00:00.123 +01:00') as timestamp_ltz1, "
...                  "to_timestamp_tz('2017-02-24 13:00:00.123 +01:00') as timestamp_tz1")
>>> df.select(is_timestamp_ntz(to_variant("timestamp_ntz1")).as_("a"),
...           is_timestamp_ntz(to_variant("timestamp_ltz1")).as_("b"),
...           is_timestamp_ntz(to_variant("timestamp_tz1")).as_("c")).collect()
[Row(A=True, B=False, C=False)]

Show lessSee more

Scroll to top