Have you noticed something new in QlikView12 and Qlik Sense timestamp parsing? UTC timestamps are automatically understood.
(Note: the output displayed below utilizes the US Date format set in the script as: SET TimestampFormat=’M/D/YYYY h:mm:ss[.fff] TT’;)
For example, the expression:
=Timestamp('20160504T142523.487-0500')
returns:
5/4/2016 7:25:23 PM
That is, the UTC offset of “-0500” is detected and the returned value is the UTC time, not the local time of 2:25:23 PM.
I can’t find anything in the help beyond an example for Timestamp# that demonstrates this but provides no detail.
This parsing functionality is particularly useful now that the QlikView Server logfiles use the UTC format for times.
I’m not sure yet if I like the automatic conversion to UTC time. For example, apps like the QlikView Governance Dashboard now report Session Start or Event times in UTC time, not local time.
It’s nice that the “T” character is understood. If you want local time, it’s easy enough to drop the offset (“-0500”) as
=Timestamp(left('20160504T142523.487-0500', 19))
which returns
5/4/2016 2:25:23 PM
-Rob
Hi I have noticed that the timestamp in the log files are now of a format of 20171124T042959.855+0000 however the governance dashboard does not pick up these files and doesnt appear to recognise the format – can you advise?
I believe the latest version of governance dashboard is supposed to process these correctly. I would check this out with QT support.
In Qlik Sense September 2017 release…I tried this within a text box: Timestamp( NOW(),’M/D/YYYY h:mm:ss[.fff] TT’)
Unfortunately this yielded: 12/16/2017 4:16:54 PM
No timezone on it 🙁
Hi John,
The output is what I would expect. Now() returns the local time, without a timezone value.
hi Rob,
we’ve upgraded from QV 11.2 to QV 12 November 2017
all logs until that time and logs from that time on are different.
does the GD support that? we have version 2.0.5 and it doesn’t…
Note the release notes for GD 205 mention something about a workaround for timestamps in certain locales. If that doesn’t fix your problem I would contact QT support.
How can we change the timestamp Format back to the Format of 11.2 in the Distribution Logfile Folder and especially in file Root_yyyymmdd.txt?
Thank you! Marcel
Hi Marcel,
I’m not sure that’s is possible to change the timestamp format. There may be a key you could add to the QVDistributionService.exe.config file, but I’m not sure. You may want to ask QT support.