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

    Difference between two dates



      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.