TimeStamp Question

[bhelms]

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.

[Gysbert_Wassenaar · Accepted solution]

Try:

DateTime2:

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

resident DateTime;

[bhelms]

Thank You, this is perfect.