Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    57

    Unanswered: Seconds to Minutes

    I have a script that returns a value in scounds, I want to convert it to a hh:mm:ss format. (ex 146 should look like 00:02:26)
    any help would be appreciated

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Code:
    SQL> var n number
    SQL> exec :n := 146
    
    PL/SQL procedure successfully completed.
    
    SQL> select to_char(trunc(sysdate)+:n/24/60/60,'HH24:MI:SS') from dual;
    
    TO_CHAR(
    --------
    00:02:26

Posting Permissions

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