Timestamp Representation

[CodeSDz]

According to this (link), a timestamp is actually a cluster of two I-64 integers.  Is there a way to extract these integers from the timestamp without converting to a double taking the integer and decimal part of the result?

[tst]

The easiest should be typecasting, but I'm not sure whether typecasting to a cluster of 2 I64s will work. You might need 4 I32 and then play around with a bit using join, etc. Unfortunately, I can't check at the moment.

[smercurio_fc]

This is what you get using the TypeCast method:

Message Edited by smercurio_fc on 08-12-2008 05:07 PM

[charmand79]

Hi,

I am trying to use a similar method to save data as fast as possible without having to convert into string first.. So, how does one get from the 3301423454.70794773 double precision number to the original timestamp Time/Date???

Many thanks,

Harry

[tst]

The numeric conversion palette has a To Time Stamp primitive.

[charmand79]

tst,

I realised that soon after I posted the question, but still thanks for the reply..

Harry