开发者

How to convert the time difference to hours(with 2 decimal place) in derby?

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?

Th开发者_StackOverflow中文版ank you.


select {fn timestampdiff(SQL_TSI_MINUTE, startdate, enddate)}/60 as diff 

and I would call the variables startdatetime and enddatetime.


Specifically for HOURS difference use "SQL_TSI_HOUR"

select {fn timestampdiff(SQL_TSI_HOUR, startdate, enddate)} as diff 

see here: https://docs.faircom.com/doc/sqlref/33476.htm

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜