How to convert the time difference to hours(with 2 decimal place) in derby?
Posted
by jl
on Stack Overflow
See other posts from Stack Overflow
or by jl
Published on 2010-03-18T08:46:48Z
Indexed on
2010/03/18
8:51 UTC
Read the original article
Hit count: 140
Hi,
I am using timestampdiff in derby db to retrieve the time difference between 2 time: startdate, and enddate. e.g.
startdate = 2010-02-23 02:59:52.045
enddate = 2010-02-23 03:45:39.898
select {fn timestampdiff(SQL_TSI_HOUR, startdate, enddate)} as diff
I would like to know how can I get the time diff in hours, e.g. 0.25, etc?
Thank you.
© Stack Overflow or respective owner