Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
DateTime2:
load timestamp(timestamp#(DateTime, 'M/D/YYYY h:mm:ss.fff'),'M/D/YYYY h:mm:ss TT') as DateTest
resident DateTime;
Try:
DateTime2:
load timestamp(timestamp#(DateTime, 'M/D/YYYY h:mm:ss.fff'),'M/D/YYYY h:mm:ss TT') as DateTest
resident DateTime;
Thank You, this is perfect.