Run ETL error on Timestamp / Not exist function to run in ETL

[FVENANCIO]

Hi, 

I have an issue when run ETL in Signavio.
Firstly, i can't use any function To_Date/To_Time or convert into TO_Timestamp in event :

I try to change in file.csv and put the date in format "dd-mm-yyyy hh:mm:ss", but when I make upload file and put the option Timestamp have error too:

In general, I can't run the ETL in any case or try de various options to try to make sucessefull

Have anybody make successful the upload file into signavio and Run ETL with success, and how could I do it?

Many Thanks

Fábio

[daniel_hesseling · Accepted solution]

Hi Fabio,

The functions you are trying to use are not part of trino which is used here.
It is best if you refer to the documentation - I think this would be the function you are looking for:

https://trino.io/docs/current/functions/datetime.html#date_parse

Importing the timestamp from CSV as STRING and then using date_parse it would be the easiest option.