https://community.databricks.com/t5/data-engineering/date-formatting/m-p/52123#M29403 <P>&nbsp;</P><P>Convert to timestamp first and then format to string</P><DIV><DIV><SPAN>select</SPAN><SPAN> &nbsp;</SPAN><SPAN>date_format</SPAN><SPAN>(to_timestamp(</SPAN><SPAN>'Dec 17 2016 8:22PM'</SPAN><SPAN>, </SPAN><SPAN>'MMM dd yyyy h:ma'</SPAN><SPAN>), </SPAN><SPAN>"yyyy-MM-dd HH:mm:ss"</SPAN><SPAN>)</SPAN></DIV></DIV><P>Here is the documentation for this:</P><P><A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-datetime-pattern.html" target="_blank">https://docs.databricks.com/en/sql/language-manual/sql-ref-datetime-pattern.html</A></P> Wed, 15 Nov 2023 19:44:55 GMT Krishnamatta 2023-11-15T19:44:55Z https://community.databricks.com/t5/data-engineering/date-formatting/m-p/52095#M29396 <P>Does anyone know how to change the format of a date like this&nbsp;</P><TABLE><TBODY><TR><TD><DIV class="">Dec 17 2016 8:22PM</DIV></TD></TR></TBODY></TABLE><P>into yyyy-MM-dd hh:mm:ss?</P><P>Thanks</P> Wed, 15 Nov 2023 17:00:14 GMT https://community.databricks.com/t5/data-engineering/date-formatting/m-p/52095#M29396 Nathant93 2023-11-15T17:00:14Z https://community.databricks.com/t5/data-engineering/date-formatting/m-p/52123#M29403 <P>&nbsp;</P><P>Convert to timestamp first and then format to string</P><DIV><DIV><SPAN>select</SPAN><SPAN> &nbsp;</SPAN><SPAN>date_format</SPAN><SPAN>(to_timestamp(</SPAN><SPAN>'Dec 17 2016 8:22PM'</SPAN><SPAN>, </SPAN><SPAN>'MMM dd yyyy h:ma'</SPAN><SPAN>), </SPAN><SPAN>"yyyy-MM-dd HH:mm:ss"</SPAN><SPAN>)</SPAN></DIV></DIV><P>Here is the documentation for this:</P><P><A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-datetime-pattern.html" target="_blank">https://docs.databricks.com/en/sql/language-manual/sql-ref-datetime-pattern.html</A></P> Wed, 15 Nov 2023 19:44:55 GMT https://community.databricks.com/t5/data-engineering/date-formatting/m-p/52123#M29403 Krishnamatta 2023-11-15T19:44:55Z