Rishabh-Pandey
Databricks MVP

Check with this method if it works.

# Convert date to MM/dd/yyyy format (string)
df = df.withColumn("formatted_date", date_format("date", "MM/dd/yyyy"))

# Convert string back to date
df = df.withColumn("converted_date", to_date("formatted_date", "MM/dd/yyyy"))

 

 

Rishabh Pandey