getting duration between two datetime in seconds

denizcaglar · #1 (**permalink**) 12-24-08, 12:23

Hi,

How can we get duration value between two datetimes in seconds.
Is there any function like datediff ??

ibm.ids · #2 (**permalink**) 12-24-08, 17:21

Again, cast is your best friend

Code:

select 
((current + 5 units day - current)::interval second(9) to second)
,((current + 5 units day - current)::interval second(9) to second)::char(10)::int8
from systables
where tabid=1

First value is interval data type and second one is int8
HTH

denizcaglar · #3 (**permalink**) 12-25-08, 05:02

Thank you for your answer.

but why is the result 0, what is the first date and the second date here ?

ibm.ids · #4 (**permalink**) 12-25-08, 11:42

First DATETIME is five days from current moment and second is current moment. So result should be 432.000 seconds (i.e. 5 * 24 * 60 * 60)

This is my result:

Code:

root@ufedora:/home/informix/ids1150uc2# dbaccess sysmaster - <<END
> select
> ((current + 5 units day - current)::interval second(9) to second)
> ,((current + 5 units day - current)::interval second(9) to second)::char(10)::int8
> from systables
> where tabid=1
> END

Database selected.



(expression)         (expression)

    432000                 432000

1 row(s) retrieved.



Database closed.

Internet Services

Web Development

Digital Marketing

Consumer Tech