Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi @Prashant_Naik ,
yes it works. The "UTC" had to be replaced to let it work.
Thank you very much!
Best.