You are viewing documentation about an older version (1.3.0). View latest version

snowflake.snowpark.functions.date_from_parts¶

snowflake.snowpark.functions.date_from_parts(y: ColumnOrName | int, m: ColumnOrName | int, d: ColumnOrName | int) → Column[source]¶

Creates a date from individual numeric components that represent the year, month, and day of the month.

Example::

>>> df = session.create_dataframe([[2022, 4, 1]], schema=["year", "month", "day"])
>>> df.select(date_from_parts("year", "month", "day")).collect()
[Row(DATE_FROM_PARTS("YEAR", "MONTH", "DAY")=datetime.date(2022, 4, 1))]
>>> session.table("dual").select(date_from_parts(2022, 4, 1)).collect()
[Row(DATE_FROM_PARTS(2022, 4, 1)=datetime.date(2022, 4, 1))]