Skip to main content
Last updated on

unix_date

Returns the number of days since 1970-01-01.

For the corresponding Databricks SQL function, see unix_date function.

Syntax​

Python
from pyspark.databricks.sql import functions as dbf

dbf.unix_date(col=<col>)

Parameters​

Parameter

Type

Description

col

pyspark.sql.Column or str

input column of values to convert.

Returns​

pyspark.sql.Column: the number of days since 1970-01-01.

Examples​

Python
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('1970-01-02',), ('2022-01-02',)], ['dt'])
df.select('*', dbf.unix_date(dbf.to_date('dt'))).show()