spark sql convert string to date

Hairy Guy answered on February 11, 2021 Popularity 9/10 Helpfulness 7/10

answer spark sql convert string to date

Comment

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

Popularity 9/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql sql-convert string to-date

Link to this answer
Share Copy Link

Contributed on Feb 11 2021

Hairy Guy

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.