Convert Date to YYYYMMDD in databricks sql

BeginnerBob
New Contributor III

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?