to_date
Converts a pyspark.sql.Column into pyspark.sql.types.DateType using the optionally specified format. Specify formats according to datetime pattern.
By default, it follows casting rules to pyspark.sql.types.DateType if the format is omitted. Equivalent to col.cast("date").
For the corresponding Databricks SQL function, see to_date function.
Syntax
Python
from pyspark.databricks.sql import functions as dbf
dbf.to_date(col=<col>, format=<format>)
Parameters
Parameter | Type | Description |
|---|---|---|
|
| input column of values to convert. |
|
| format to use to convert date values. |
Returns
pyspark.sql.Column: date value as pyspark.sql.types.DateType type.
Examples
Python
from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('1997-02-28 10:30:00',)], ['ts'])
df.select('*', dbf.to_date(df.ts)).show()
df.select('*', dbf.to_date('ts', 'yyyy-MM-dd HH:mm:ss')).show()