HDIFF does not show correct result

October 13, 2006, 07:31 PM

Hi All,

I need to find the difference between 2 datetime fields in hours.

CASE 1:

STARTDATETIME - 12-SEP-2006 05:46:29
ENDDATETIME - 12-SEP-2006 05:58:10
In Oracle, (ENDDATETIME - STARTDATETIME)*24, results in .194722222222222222222222222222222222222
In WF, DATEDIFF/D20.18=HDIFF(ENDDATETIME,STARTDATETIME,'HOUR', 'D20.18');, results in .000000000000000000

CASE 2:

STARTDATETIME - 12-SEP-2006 01:44:15
ENDDATETIME - 12-SEP-2006 06:21:39
In Oracle, (ENDDATETIME - STARTDATETIME)*24, results in 4.62333333333333333333333333333333333333
In WF, DATEDIFF/D20.18=HDIFF(ENDDATETIME,STARTDATETIME,'HOUR', 'D20.18');, results in 5.000000000000000000

Thanks in advance.

Dan

Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE

October 13, 2006, 07:46 PM

N.Selph

Why not get the difference in seconds and convert it to hour fractions?

October 13, 2006, 07:59 PM

dballest

quote:
N.Selph

Thanks N.Selph! That worked!