Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    8

    Unanswered: converting minutes to seconds in query

    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?

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Talking

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •