Hi All,

I'm struggling to find out a way to extract seconds equivalent of hour and minutes from datetime as a query output, for example:

fragment_col = '2010-05-26 14:30'


So some thing like -->

"select fragment_col from myTable where cond1=cond2"
output: '2010-05-26 14:30'

But expected output is 14*60+30=870

Any help appreciated.

Thanks
Sahoo

Any help on this please.

Thanks
Sahoo

After looking at the docs a little bit I can't find anything equivalent to an Hour() function, so you might have to tackle this a slightly harder way...

the TO_CHAR() function will convert the datetime in to a string, then you will have to use string manipulation to extract the relevant time portions, convert these back to integers and apply the necessary math.

Hope this helps