Calculate the difference in seconds for two timestamps field

jiegao · Post by **jiegao** » Wed Oct 03, 2012 10:53 am

Hi.
I am wondering what is the best way to calcuate the difference in seconds for two timestamps fields in Server job. Thanks in advance.

ArndW · Post by **ArndW** » Wed Oct 03, 2012 11:01 am

Server jobs don't have a timestamp data type, so you would need to separate the date and time portions of the string, then use ICONV to convert the two parts, perform the delta math, the use OCONV again to build the timestamp.

jiegao · Post by **jiegao** » Wed Oct 03, 2012 11:58 am

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Oct 03, 2012 3:15 pm

Something like this will do the task. Error handling has been omitted for clarity.

Code: Select all

FUNCTION TimestampDiff(Timestamp1,Timestamp2)
Day1 = Field(Timestamp1, " ", 1, 1)
Day2 = Field(Timestamp2, " ", 1, 1)
Time1 = Field(Timestamp1, " ", 2, 1)
Time2 = Field(Timestamp2, " ", 2, 1)
Seconds1 = Iconv(Time1, "MT") + 86400 * Iconv(Time1, "DYMD")
Seconds2 = Iconv(Time2, "MT") + 86400 * Iconv(Time2, "DYMD")
Ans = Seconds2 - Seconds1
RETURN(Ans)