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

    Time problem

    steve peroni


      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