Nóta
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað aðskrá þig inn eða breyta skráasöfnum.
Aðgangur að þessari síðu krefst heimildar. Þú getur prófað að breyta skráasöfnum.
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
from pyspark.sql import functions as dbf
dbf.to_date(col=<col>, format=<format>)
Parameters
| Parameter | Type | Description |
|---|---|---|
col |
pyspark.sql.Column or str |
input column of values to convert. |
format |
literal string, optional |
format to use to convert date values. |
Returns
pyspark.sql.Column: date value as pyspark.sql.types.DateType type.
Examples
from pyspark.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()