BusinessObjects Board

Seconds between dates

building reports desktopintelligence
#1

Hi,

Here is the requirement.

Fund date in mm/dd/yyyy format
Fund Time in hh:mm:ss format

Req date in mm/dd/yyyy format
Req Time in hh:mm:ss format

Database is Oracle 9i.

Need difference between these (Fund date:Time )- (Req date:time) in seconds.
:slight_smile:
thanks
Praveen

Sky :india: (BOB member since 2005-08-04)

#2

https://bobj-board.org/t/21735

jobjoris :netherlands: (BOB member since 2004-06-30)

#3

Thanks.

I am looking for oracle solution.

Sky

Sky :india: (BOB member since 2005-08-04)

#4

I think the link which jobjoris provided works at the reporter… level.
that will work for ORACLE as well.

:yesnod:

BO_Chief :us: (BOB member since 2004-06-06)

#5

Does that mean you are looking for a Designer solution? If so, we can move this topic to the Semantic Layer forum.

That said, if your dates are true datetime fields, the Oracle solution is rather simple

(tbl.FundDate - tbl.ReqDate) * 86400

Simple Oracle date math returns days … any fractional days as a decimal (.5 = 12 hours, for example) … multiply that by 86400 (number of seconds in one day) and that’s the answer.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)