time diff in minutes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: time diff in minutes

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    time diff in minutes

    multiply with 1440 and take the round of the result.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    This is correct:

    SQL> select round((to_date('01/01/01 01:15:00','mm/dd/yy hh24:mi:ss')-to_date('01/01/01 01:00:00','mm/dd/yy hh24:mi:ss'))*1440) from dual;

    ROUND((TO_DATE('01/01/0101:15:00','MM/DD/YYHH24:MI:SS')-TO_DATE('01/01/0101:00:00','MM/DD/YYHH24:MI:
    ----------------------------------------------------------------------------------------------------
    15

Posting Permissions

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



Click Here to Expand Forum to Full Width