https://community.databricks.com/t5/data-engineering/unable-to-convert-to-date-from-datetime-string-with-am-and-pm/m-p/102862#M41254 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/110498">@David_Billa</a>,</P> <P>Can you try with:</P> <P class="p1">TO_TIMESTAMP("12/30/2022 12:00:00 AM", "MM/dd/yyyy hh:mm:ss a") AS tsDate</P> <P class="p1">The issue you are encountering with the TO_DATE function returning null for the value "12:00:00 AM" is likely due to the format string not matching the input string correctly. The TO_DATE function in Databricks requires the format string to precisely match the input string for it to parse the date correctly</P> <P class="p1"><A href="https://docs.databricks.com/ja/sql/language-manual/functions/to_timestamp.html" target="_blank">https://docs.databricks.com/ja/sql/language-manual/functions/to_timestamp.html</A></P> Fri, 20 Dec 2024 19:20:19 GMT Alberto_Umana 2024-12-20T19:20:19Z https://community.databricks.com/t5/data-engineering/unable-to-convert-to-date-from-datetime-string-with-am-and-pm/m-p/102861#M41253 <P>Any help to understand why it's showing 'null' instead of the date value? It's showing null only for 12:00:00 AM and for any other values it's showing date correctly</P><LI-CODE lang="markup">TO_DATE("12/30/2022 12:00:00 AM", "MM/dd/yyyy HH:mm:ss a") AS tsDate</LI-CODE><P>&nbsp;</P> Fri, 20 Dec 2024 18:54:41 GMT https://community.databricks.com/t5/data-engineering/unable-to-convert-to-date-from-datetime-string-with-am-and-pm/m-p/102861#M41253 David_Billa 2024-12-20T18:54:41Z https://community.databricks.com/t5/data-engineering/unable-to-convert-to-date-from-datetime-string-with-am-and-pm/m-p/102862#M41254 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/110498">@David_Billa</a>,</P> <P>Can you try with:</P> <P class="p1">TO_TIMESTAMP("12/30/2022 12:00:00 AM", "MM/dd/yyyy hh:mm:ss a") AS tsDate</P> <P class="p1">The issue you are encountering with the TO_DATE function returning null for the value "12:00:00 AM" is likely due to the format string not matching the input string correctly. The TO_DATE function in Databricks requires the format string to precisely match the input string for it to parse the date correctly</P> <P class="p1"><A href="https://docs.databricks.com/ja/sql/language-manual/functions/to_timestamp.html" target="_blank">https://docs.databricks.com/ja/sql/language-manual/functions/to_timestamp.html</A></P> Fri, 20 Dec 2024 19:20:19 GMT https://community.databricks.com/t5/data-engineering/unable-to-convert-to-date-from-datetime-string-with-am-and-pm/m-p/102862#M41254 Alberto_Umana 2024-12-20T19:20:19Z