1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

TimeStamp

Discussion in 'SQL PL/SQL' started by NKT, May 4, 2009.

  1. NKT

    NKT Guest

    How can I find the difference between two time stamp as one value. For example time2-time1 should return something like 0.328,

    I could use SELECT SUM(TIME2-TIME1) to do this in I think Oracle 8g and I can't use the same on 11g, what should I use to get the difference between time stamps.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India