Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try this
=interval(Filed1- Field2, 'hh')
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
Hi,
try this:
=Interval(Timestamp2-timestamp1,'HH')