Date formatting

[Nathant93]

Does anyone know how to change the format of a date like this 

Dec 17 2016 8:22PM

into yyyy-MM-dd hh:mm:ss?

Thanks

[Krishnamatta · Accepted solution]

Convert to timestamp first and then format to string

select  date_format(to_timestamp('Dec 17 2016 8:22PM', 'MMM dd yyyy h:ma'), "yyyy-MM-dd HH:mm:ss")

Here is the documentation for this:

https://docs.databricks.com/en/sql/language-manual/sql-ref-datetime-pattern.html