timestamp behaviour

[#1]

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 · Accepted solution]

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'));

[#3]

Thanks...it works