topic Re: Convert Date to YYYYMMDD in databricks sql in Data Engineering

Convert Date to YYYYMMDD in databricks sql

BeginnerBob — Mon, 18 Jul 2022 15:33:55 GMT

Hi,

I have a date column in a delta table called ADate. I need this in the format YYYYMMDD.

In TSQL this is easy. However, I can't seem to be able to do this without splitting the YEAR, MONTH and Day and concatenating them together.

Any ideas?

Re: Convert Date to YYYYMMDD in databricks sql

AmanSehgal — Tue, 19 Jul 2022 01:46:56 GMT

@Lloyd Vickery could you please share a sample of what date looks like in your delta table and desired output?

Re: Convert Date to YYYYMMDD in databricks sql

Atanu — Tue, 19 Jul 2022 13:26:13 GMT

https://community.databricks.com/s/question/0D58Y00008xpCB8SAM/convert-date-to-yyyymmdd-in-databricks-sql this might be helpful. let me know @Lloyd Vickery

Re: Convert Date to YYYYMMDD in databricks sql

Vidula — Mon, 05 Sep 2022 10:20:37 GMT

Hello @Lloyd Vickery

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Convert Date to YYYYMMDD in databricks sql

hbenzineb — Wed, 11 Jan 2023 17:12:09 GMT

Hello,

You can use the function date_format(your_date_column, 'yyyyMMdd')

Re: Convert Date to YYYYMMDD in databricks sql

JayDoubleYou42 — Wed, 10 Apr 2024 01:35:05 GMT

I'll share I'm having a variant of the same issue. I have a varchar field in the form YYYYMMDD which I'm trying to join to another varchar field from another table in the form of MM/DD/YYYY. Does anyone know of a way to do this in SPARK SQL without splitting the YEAR, MONTH and Day and concatenating them together? I've tried date_format, to_date, date, cast, and to_timestamp functions or different combinations of them, but haven't yet succeeded. Any help is appreciated. Thanks!

Re: Convert Date to YYYYMMDD in databricks sql

-werners- — Wed, 10 Apr 2024 06:33:02 GMT

basically with to_date() and date_format() you can play with dates all you want.
to_date converts a string to a date (with the format the datestring is in as a parameter), and date_format converts a date to a string (with the format the output has to be in as a parameter).