Skip to main content

make_date

Returns a column with a date built from the year, month and day columns.

For the corresponding Databricks SQL function, see make_date function.

Syntax

Python
from pyspark.databricks.sql import functions as dbf

dbf.make_date(year=<year>, month=<month>, day=<day>)

Parameters

Parameter

Type

Description

year

pyspark.sql.Column or str

The year to build the date

month

pyspark.sql.Column or str

The month to build the date

day

pyspark.sql.Column or str

The day to build the date

Returns

pyspark.sql.Column: a date built from given parts.

Examples

Python
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(2020, 6, 26)], ['Y', 'M', 'D'])
df.select('*', dbf.make_date(df.Y, 'M', df.D)).show()