Oracle SQL Input tool error "Function 'TRUNC(TIMESTAMP)' does not exist"

[GoldenDesign04]

Heyo everyone. I am having a unique error in some SQL from an Alteryx input. This query was originally for a Netezza box but we migrated hosts to Oracle OCI cloud. 
I modified the existing SQL to syntax appropriate for Oracle versus Netezza but am getting an interesting error:

I've attached the SQL here. The only syntax that did change was originally I used to_date and with Oracle the DB management team suggested a swap to trunc(xxx)
I cannot fathom where the error is coming from as the query runs perfectly fine in DBeaver
The only area that is using trunc is applying to a timestap data type and the system clock current_date
My only guess is this is a fluke in Alteryx SQL in the Input data tool any suggestions?

[mceleavey]

Hi @GoldenDesign04 ,

this might be because Oracle is not recognising the TIMESTAMP correctly. Try wrapping that in a CAST function, maybe converting to varchar before truncating.

M.