pyspark.sql.functions.date_sub

pyspark.sql.functions.date_sub(start: ColumnOrName, days: Union[ColumnOrName, int]) → pyspark.sql.column.Column[source]

Returns the date that is days days before start

New in version 1.5.0.

Examples

>>> df = spark.createDataFrame([('2015-04-08', 2,)], ['dt', 'sub'])
>>> df.select(date_sub(df.dt, 1).alias('prev_date')).collect()
[Row(prev_date=datetime.date(2015, 4, 7))]
>>> df.select(date_sub(df.dt, df.sub.cast('integer')).alias('prev_date')).collect()
[Row(prev_date=datetime.date(2015, 4, 6))]