PDA

View Full Version : converting minutes to seconds in query

akozenler
06-14-02, 10:23
Hi I have a column containing time in 00:00 format .I want to take a report but i have to convert it in seconds.Can you help me?
alligatorsql.com
06-14-02, 20:06
Hello,

what about

select to_number(to_char(field, 'HH24'))*60*60+(to_number(to_char(field, 'MI')*60)) from table ?????

Hope that helps ?

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com