pyspark convert dataframe column from timestamp to string of "YYYY-MM-DD" format

Question

In pyspark is there a way to convert a dataframe column of timestamp datatype to a string of format 'YYYY-MM-DD' format?

Answer 1

You can use date_format function as below

from pyspark.sql.functions import date_format

df.withColumn("dateColumn",  date_format(col("vacationdate"), "yyyy-MM-dd"))

Hope this helps!