Date format statements in Spark SQL Query nodes

Hi, I have a question for the Nim Support team.

I am currently trying to create a date column via Spark SQL Query.

When I run the query below, the date data is generated in a different format and not represented in the actual table like yyyy-MM-dd(2024-04-02) which is what I want. How can I resolve these issues?

SELECT year,month,day,

TODATE(CONCATWS(“-”,

year

,LPAD(

month

,2,‘0’),LPAD(

day

,2,‘0’)),‘yyyy-MM-dd’) AS DATE

FROM #table#