snowflake.snowpark.functions.is_date_value¶

snowflake.snowpark.functions.is_date_value(col: ColumnOrName) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L2907-L2920)¶

Returns true if the specified VARIANT column contains a date value.

Examples:

CopyExpand

>>> import datetime
>>> from snowflake.snowpark.types import StructField, VariantType
>>> df = session.create_dataframe([[datetime.date(2023, 3, 2), 123]], schema=["a", "b"])
>>> df.select(is_date(to_variant(df["a"])).alias("date"), is_date(to_variant(df["b"])).alias("int")).collect()
[Row(DATE=True, INT=False)]

Show lessSee more

Scroll to top