BusinessObjects Board

Time Difference in Web Intelligence

Is there any way to calculate time (hour) difference of 2 dates??

vijesh.chandra :india: (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.ganga1 :us: (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 :india: (BOB member since 2008-05-12)