How to find out the hours between the days

[venkatbza]

Hi Friends,

I have two timestamps and need to find out the hours between that timestamps. Please help me how to find.

timestamp 1)      2017-07-21 21:00:00

timestamp 2)      2017-07-24 15:50:48

Thanks,

Venakt

[Chanty4u]

try this

=interval(Filed1- Field2, 'hh')

[MK_QSL · Accepted solution]

SET TimestampFormat='YYYY-MM-DD hh:mm:ss';

Data:

Load T1, T2 Inline

[

T1, T2

2017-07-21 21:00:00,2017-07-24 15:50:48

];

=Interval(T2-T1)*24

[YoussefBelloum]

Hi,

try this:

=Interval(Timestamp2-timestamp1,'HH')