snowflake.snowpark.functions.is_timestamp_ntz¶
- snowflake.snowpark.functions.is_timestamp_ntz(col: Union[Column, str]) Column [source]¶
Returns true if the specified VARIANT column contains a TIMESTAMP_NTZ value with no time zone.
Example:
>>> 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)]