pyspark.sql.functions.date_sub¶
-
pyspark.sql.functions.
date_sub
(start: ColumnOrName, days: Union[ColumnOrName, int]) → pyspark.sql.column.Column¶ Returns the date that is days days before start
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))]