Is there any way to calculate time (hour) difference of 2 dates??
vijesh.chandra (BOB member since 2009-05-29)
Is there any way to calculate time (hour) difference of 2 dates??
vijesh.chandra (BOB member since 2009-05-29)
There is no standard way, you need to do some work around. Here is some sample code which we use with Free hand sql
To convert date into hours:
extract(day from (Date))*24+extract(hour from (Date))
Hope this helps you.
Anil.
anil.ganga1 (BOB member since 2007-07-04)
See Marek’s suggestion here.
P.S: Modify the code to get it worked in Web-I as it was for Desk-I.
Jansi (BOB member since 2008-05-12)