Hi, I have a UTC Timestamp field which I need to convert into number of hours. Can anybody help?
Phill
Hello… I had to convert a Unix Timestamp to DateTime on a dataport (in). I know this isn’t exactly what you want but it might help.
So below where Date is actually a DateTime variable and varDur is a Duration variable. Timestamp is the Unix Timestamp.
OnInsert()
Date := CREATEDATETIME(010170D,000000T);
varDur := (Timestamp) * 1000;
Date := Date + varDur;
Tom