TO_TIMESTAMP_TZ not handled

[omnishantg]

Is there a way to handle the TO_TIMESTAMP_TZ function in snowflake when transpiling to other dialects?

Thanks!

[georgesittas]

Do you have a specific use case in mind that you would like SQLGlot to support?

[omnishantg]

SELECT date_part(epoch_second,TO_TIMESTAMP_TZ(timetsamp_col)) as ddate FROM ttable ;

The above query in snowflake needs to be translated to presto

[tobymao]

we have TIMESTAMP WITH TIMEZONE