nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

convert a String like 123:34:23 to actual Time format

Priyankita Devi

[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]

Find more posts tagged with

Comments

kclark

You can create a computed column and calculate the date from that value using some javascript. Can you give a couple examples of the date you're wanting to covnert and I'll write up a function.