#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    1
    Rep Power
    0

    subtracting time in oracle


    Hi,

    I want to test how long something takes to load. In my table I have a start_time and an end_time in format
    dd-mon-yyyy hh24:mi:ss. If I want to get the difference in minutes, how would I do that.

    Ex. start_time = '02-Feb-2004 01:19:02'
    end_time = '02-Feb-2004 01:19:48'

    The result should be 46 seconds.

    When I tried to subtract the time by minutes I got some strange results. Please help.

    thanks
    L.Das
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    (enddate-startdate)/24/60

IMN logo majestic logo threadwatch logo seochat tools logo