Format and load as timestamp

[Applicable88]

Hello,

I have several timestampt fields, but i didn't get them to load correctly into Qliksense.

For example my field STARTINGTIME looks like this: 

2020-10-27 13:21:02 UTC 

I did something like:

timestamp#(STARTINGTIME,  'YYYY-MM-DD hh:mm:ss)  as STARTINGTIME

or 

Timestampt(timestamp#(STARTINGTIME,  'YYYY-MM-DD hh:mm:ss))  as STARTINGTIME

None of these methods workout. Not even recognized in the Datamanager as Timestamp, but only as "General"

And if I try to change in Datamanger manually I got NULL data. 

I hope someone has the right, solution.

Best

[Prashant_Naik · Accepted solution]

HI,

This might help you.

load *,

TimeStamp(Timestamp#(replace('2020-10-27 13:21:02 UTC',' UTC',''),'YYYY-MM-DD hh:mm:ss')) as NewTime

from table;

Regards,

Prashant

[Applicable88]

Hi @Prashant_Naik ,

yes it works. The "UTC" had to be replaced to let it work. 

Thank you very much!

Best.