convert a time field in Oralce to a number

[jimmy80]

Hi,

I need to convert a time field in the format hh24:mi:ss to a number in the format hhmiss - I have tried using to the to_number function but amn't having any success...
Any chance anyone knows how I can do this?

Thanks for your help,
jim

 

[sem]

Try, TO_CHAR(<YOUR DATE>, 'hhmiss') though I can't understand how to work with this number

Regards, Dima