11 Replies Latest reply: May 4, 2016 2:41 PM by Prashanth Reddy Nasi RSS

    Calculate difference between two dates?

    Prashanth Reddy Nasi

      HI all,

      I have two date fields, I have to calculate the difference in hours. viz., open date and close date.

      Open_Date                  Close_Date

      10/01/2016 08:20:00     12/01/2016 9:50:00

       

      I used timestamp for both the columns and on the result also.

      Eg: timestamp(Close_Date) - timestamp(Open_Date )  as Cycletime

      Now i am getting the time in hours and minutes as below.

      Eg: difference between abve dates is 49:30:00.

      What I am expecting is like 49.50 hours(I have to calculate that 30 minutes into hours then add that to the 49 hours)

       

      Thanks for any ideas.

       

      regards

      Prashanth