Time problem

[Anonymous]

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

[CELAMBARASAN]

To get hour use interval function itself

Interval(runtime, 'hh')

because hour is upto 23 hours only it consider hour for a day.

[Anonymous]

Thanks very much !!!