pyspark.sql.functions.date_diff#

pyspark.sql.functions.date_diff(end, start)[source]#

Returns the number of days from start to end.

New in version 3.5.0.

Parameters
endColumn or str

to date column to work on.

startColumn or str

from date column to work on.

Returns
Column

difference in days between two dates.

Examples

>>> df = spark.createDataFrame([('2015-04-08','2015-05-10')], ['d1', 'd2'])
>>> df.select(date_diff(df.d2, df.d1).alias('diff')).collect()
[Row(diff=32)]