Using string formatter for Teradata to Databricks

[Ashay4u]

I am trying to transpile a Teradata code to databricks. The query is somewhat like below. I made certain mods to the code which helped me get around the Volatile keyword and changes to _parse_cast to read the format keyword after the code checks for "this" and "to". But I am not able to figure out how I can change to tranpiled code to use date_format function instead of 'cast' and specify the format in there. Can you help me out?

create volatile table temp2
as(
select
CAST ('1992-01' AS DATE FORMAT 'YYYY-DD') as cast_Date_format
from
hive_metastore.default.dim_cal_day
where cal_dt between add_months(current_date,-1) and current_date
);

[treysp]

Hello, thanks for reaching out about this!

I'll take a look later today - could you provide the databricks sql that should be output from transpiling the above code?

[Ashay4u]

For the query above it should look something like this date_format('1992-01','yyyy-dd')
If it was a string without hyphens it would be something like this date_format(to_date('199201','yyyyMM'),'yyyy-MM')

[treysp]

The date format component has been fixed in this commit. Almost finished addressing the volatile keyword.