2 Replies Latest reply: Dec 11, 2012 3:43 PM by steve peroni RSS

    Time problem

    steve peroni

      Hi,

      I calculated the runtime by the interval(EndTimeStamp - StartTimeStamp) and the result is  hh:mm:ss

       

      Now if I do hour(runtime) I get the right value for all the intervals which have hour <= 23

      If my interval is longer than 24 hours, the system always display 23. For example:

       

      EndTimeStamp  11 - december - 2012    15:00:00

      StartTimeStamp   8  december  2012      13:00:00

          

      The interval is  70:00:00 but it displays 23 and it's wrong

       

      Any help for me ?  Thanks in advance for your help