Databricks YYYYMMDD to Date


      Databricks YYYYMMDD to Date

In Databricks, you can convert a string representing a date in the YYYYMMDD format to a date type using the to_date function:


SELECT to_date(‘20230521’, ‘yyyyMMdd’) AS converted_date;

This query will output:



  1. to_date('20230521', 'yyyyMMdd'):

    • '20230521': The input string in YYYYMMDD format.
    • 'yyyyMMdd': The format specification tells Databricks how to interpret the input string.
  2. AS converted_date: This renames the resulting column to converted_date for clarity.

Important Notes:

  • Spark SQL DateType: The resulting date is in the standard Spark SQL DateType format (yyyy-MM-dd).
  • Error Handling: If the input string does not match the specified format (yyyyMMdd), the to_date function will raise an error.
  • Alternative: You can also use the cast function if you don’t need to specify a custom format:
    SELECT cast(‘20230521’ AS date) AS converted_date;
    However, this assumes the date string is already in the default format recognized by Spark (yyyy-MM-dd).

Databricks Training Demo Day 1 Video:

You can find more information about Databricks Training in this Dtabricks Docs Link



Unogeeks is the No.1 IT Training Institute for Databricks Training. Anyone Disagree? Please drop in a comment

You can check out our other latest blogs on Databricks Training here – Databricks Blogs

Please check out our Best In Class Databricks Training Details here – Databricks Training

 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *