11 Replies Latest reply: Feb 23, 2012 8:15 AM by Fernando Tonial RSS

    Difference between two dates

      Hi!,

       

      I have two dates and i want to calculate the difference between the two in hours. Not sure which function i have to use or how to go about it . Can somebody throw some light on this.

       

      Also in other requirement i want to subtract 2 hrs from my time stamp.

       

      The format in which in which i am getting date and time from SQL is '2012-02-22 13:20:00.000'

       

      Thanks in advance.