Calculating time differences in informix

keimo · #1 (**permalink**) 04-15-03, 02:52

Hi, I'm new to all this, so bare with me. I have a problem with unix time and "people" time. What I would need to do, is calculate time diffirence between 2 timestamps, so I have starttime and endtime in unixtime, and I need the result to be people time. You guys have any suggestions how to do this ?
Thanks in advance,
Keimo

keimo · #2 (**permalink**) 04-15-03, 02:58

Hi, I would need the result like HH:MIN

EC .
Thanks,
Keimo

eherber · #3 (**permalink**) 04-16-03, 10:11

You might try this:

select extend(dbinfo("utc_to_datetime", <diff_seconds>), hour to second)
from systables where 1=1