Eclipse Community Forums: BIRT » calculate duration in BIRT

Help

Home

Home » Archived » BIRT » calculate duration in BIRT

Show: Today's Messages :: Show Polls :: Message Navigator

calculate duration in BIRT [message #539328]

Thu, 10 June 2010 12:49

No real name

Messages: 17
Registered: June 2010

Junior Member

Hi,

Thanks for reading.

I'm a BIRT newbie.
Please how can I calculate duration from two data fields in my dataset. the sql duration doesn't seem to be supported in BIRT.
When I try subtraction of one date from the other, I get a NaN, as I try a float datatype.

Thanks for your answer.

Ime

Report message to a moderator

Re: calculate duration in BIRT [message #539351 is a reply to message #539328]

Thu, 10 June 2010 14:06

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

I would try the BirtDateTime functions, though I usually do this sort of thing on the database side. There are a couple of things you have to consider. One, what database are you using, what is the datatype (DATE, or DATETIME), and what resolution do you want in your duration (raw number of seconds, difference in minutes, days, etcetera).

If you're looking to use (in effect) the SQL-92 INTERVAL data type as your result, someone else will need to help you as I have never needed to use that facility.

Report message to a moderator

Re: calculate duration in BIRT [message #539373 is a reply to message #539351]

Thu, 10 June 2010 14:53

No real name

Messages: 17
Registered: June 2010

Junior Member

Thanks Richard. I was just discussing with a colleague and we decided also to do this on the database side through our service layer...that is add methods to do this and persist through the POJO.

Will be storing the raw number of days as float.

Thanks again. I'm loving this forum Smile

Ime

Report message to a moderator

Previous Topic:	Stack Overflow deploying Birt on Websphere 6.1 with Java2 Security
Next Topic:	Populating a table column-by-column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:47:31 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter