snowflake.snowpark.functions.as_time¶

snowflake.snowpark.functions.as_time(variant: ColumnOrName) → Column[source]¶

Casts a VARIANT value to a time value.

Example:

CopyExpand

>>> from snowflake.snowpark.functions import as_time, to_variant
>>> df = session.sql("select TO_TIME('12:34:56') as alarm")
>>> df.alarm_v = to_variant(df.alarm)
>>> df.select(df.alarm_v.as_("alarm")).collect() == df.select(df.alarm).collect()
False
>>> df.select(as_time(df.alarm_v).as_("alarm")).collect() == df.select(df.alarm).collect()
True

Show lessSee more

Scroll to top