topic timestamp behaviour in QlikView

timestamp behaviour

Wed, 02 Oct 2013 15:19:52 GMT

Hi Guys,

I have this sample code

let b = Timestamp(41547.9209375, 'YYYYMMDDhmmss.fff');

SET a='20130930220609.000';

let gdate = num(Timestamp#(a, 'YYYYMMDDhmmss.fff'));

the value of b is 20130930220609.000 which is same as 'a' but when i use timestamp# on a then i get 41547.104270833 in return.

This look weird to me because I am expecting it to be same as 41547.9209375.

Can someone help me the reason for it?

Saurabh

Gysbert_Wassenaar — Wed, 02 Oct 2013 15:59:32 GMT

I think it's because you use only one digit for the hour. Try using hh instead of h:

let gdate = num(Timestamp#(a, 'YYYYMMDDhhmmss.fff'));

Thu, 03 Oct 2013 14:06:30 GMT

Thanks...it works