Eclipse Community Forums: BIRT » Convert a String like 123:34:23 to actual Time format in birt report designer

Help

Home

Home » Archived » BIRT » Convert a String like 123:34:23 to actual Time format in birt report designer

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

Convert a String like 123:34:23 to actual Time format in birt report designer [message #1283325]

Thu, 03 April 2014 09:39

Priyankita Devi

Messages: 1
Registered: April 2014

Junior Member

Can BIRT Designer convert a String like 123:34:23 to actual Time format so that we can perform calculations and produce graphs on them? The reason why its a string is as far as I know there is no Time format in Oracle which is the DB we are using.We cant convert it using to_date as the hours are summed and therefore go above the standard 24 hours and Oracle throws the error to say you cant have more than 24 hours in an hour.

Report message to a moderator

Re: Convert a String like 123:34:23 to actual Time format in birt report designer [message #1288779 is a reply to message #1283325]

Tue, 08 April 2014 21:33

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Your best bet might be to create a computed column to split your string and calculate it as seconds. Then, you can use the seconds column to do your calculations and form your hh:mm:ss string when you want to display values. Your other option would be to create a DateTime field and use it for your calculations, but then you'd have to deal with the days portion of things since your values go over 24 hours.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Limiting the time the IRunAndRenderTask runs
Next Topic:	Via scripting - change Pie chart legend position from left to right

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 23:49:52 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter