Databricks Community

David_Billa

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 correctlyTO_DATE("12/30/2022 12:00:00 AM", "MM/dd/yyyy HH:mm:ss a") AS tsDate

David_Billa

TO_DATE("12/30/2022 10:30:00 AM", "MM/dd/yyyy HH:mm:ss a") AS tsDateIs this correct if we need only date?

Databricks Community

User Stats

User Activity

Unable to convert to date from datetime string with AM and PM

Re: How to convert string to datetime with correct timezone?