try_to_date
This is a special version of to_date that performs the same operation, but returns a NULL value instead of raising an error if date cannot be created.
Added in Databricks Runtime 17.2
Syntax
Python
from pyspark.sql import functions as dbf
dbf.try_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.sql import functions as dbf
df = spark.createDataFrame([('1997-02-28',)], ['ts'])
df.select('*', dbf.try_to_date(df.ts)).show()
df.select('*', dbf.try_to_date('ts', 'yyyy-MM-dd')).show()
df = spark.createDataFrame([('foo',)], ['ts'])
df.select(dbf.try_to_date(df.ts)).show()