Piezīmes
Lai piekļūtu šai lapai, ir nepieciešama autorizācija. Varat mēģināt pierakstīties vai mainīt direktorijus.
Lai piekļūtu šai lapai, ir nepieciešama autorizācija. Varat mēģināt mainīt direktorijus.
Returns the date that is days days before start. If days is a negative value then these amount of days will be added to start.
For the corresponding Databricks SQL function, see date_sub function.
Syntax
from pyspark.databricks.sql import functions as dbf
dbf.date_sub(start=<start>, days=<days>)
Parameters
| Parameter | Type | Description |
|---|---|---|
start |
pyspark.sql.Column or str |
date column to work on. |
days |
pyspark.sql.Column or str or int |
how many days before the given date to calculate. Accepts negative value as well to calculate forward in time. |
Returns
pyspark.sql.Column: a date before/after given number of days.
Examples
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('2015-04-08', 2,)], 'struct<dt:string,a:int>')
df.select('*', dbf.date_sub(df.dt, 1)).show()
df.select('*', dbf.date_sub('dt', 'a')).show()
df.select('*', dbf.date_sub('dt', dbf.lit(-1))).show()