how to ocnvert string to datetime in spark sql using spark.sql code example

Example: spark sql convert string to date

spark.sql("""
  SELECT TO_DATE(CAST(UNIX_TIMESTAMP('12/31/2049', 'MM/dd/yyyy') AS TIMESTAMP)) AS newdate"""
).show()