snowflake.snowpark.functions.date_add¶

snowflake.snowpark.functions.date_add(col: Union[Column, str], num_of_days: Union[Column, str, int])[source]¶

Adds a number of days to a date column.

Parameters:

• col – The column to add to.

• num_of_days – The number of days to add.

Example:

CopyExpand

>>> from snowflake.snowpark.functions import date_add, to_date
>>> df = session.createDataFrame([("1976-01-06")], ["date"])
>>> df = df.withColumn("date", to_date("date"))
>>> res = df.withColumn("date", date_add("date", 4)).show()
--------------
|"DATE"      |
--------------
|1976-01-10  |
--------------

Show lessSee more

Scroll to top