Hi,

What is the best way to get the time difference in seconds in DB2

For eg, the query below

select ( timestamp_format( '2008-03-13 09:06:00', 'yyyy-mm-dd
hh24:mi:ss' )-
timestamp_format( '2008-03-13 09:05:00', 'yyyy-mm-dd hh24:mi:ss'
)
)
From sysibm.sysdummy1


Returns:

100


How do I convert this into seconds?


Thanks,
Ashim.


DB2 & UDB email list listserv db2-l LazyDBA home page