Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
convert a String like 123:34:23 to actual Time format
Migrateduser
<p>[font="Calibri, 'sans-serif';color:#000000;"]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. [/font]</p><p></p>
Find more posts tagged with
Comments
There are no comments yet