TimeStamp Question

bhelms — Tue, 17 Dec 2013 17:46:40 GMT

I cannot figure this out and it is starting to make me angry so I am hoping someone smarter than me can help.

I have a log file that has a timestamp in the following format "12/16/2013 23:50:18.7905230". I am simply trying to pull this into QlikView, and format it as a proper timestamp. I can't figure out the scripting for it. You can recreate my issue with the following code. Any help would be appreciated.

DateTime:

Load * Inline [
DateTime
'12/16/2013 23:50:18.7905230'
];

DateTime2:
Load TimeStamp(DateTime, 'M/D/YYYY h:mm:ss TT') as DateTest
Resident DateTime;

I have tried a ton of things to get DateTest to format properly but haven't figured it out yet. Thanks For the help.

Re: TimeStamp Question

Gysbert_Wassenaar — Tue, 17 Dec 2013 18:14:18 GMT

Try:

DateTime2:

load timestamp(timestamp#(DateTime, 'M/D/YYYY h:mm:ss.fff'),'M/D/YYYY h:mm:ss TT') as DateTest

resident DateTime;

Re: TimeStamp Question

bhelms — Tue, 17 Dec 2013 18:58:50 GMT

Thank You, this is perfect.

topic Re: TimeStamp Question in QlikView

TimeStamp Question

Re: TimeStamp Question

Re: TimeStamp Question