Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi People,
I am trying to calculate an interval based on the following
Timetamp: 10/11/2019 12:53:14
My expression:
Interval(Time(Maketime(18,00,00))-Time(Timetamp))
The result:
-1050690:53:14
What am I doing wrong?
Thanks!
Hi, try this script:
temp:
LOAD *,
INTERVAL(MAKETIME(18,0,0)-time) as time_diff;
LOAD *,
TIME(FRAC(timestamp_field)) as time;
LOAD
TIMESTAMP(TIMESTAMP#(timestamp_field,'DD/MM/YYYY hh:mm:ss')) AS timestamp_field
INLINE [
timestamp_field
10/11/2019 12:53:14
10/11/2019 13:41:10
10/11/2019 17:17:53
]
;
Hi, try this script:
temp:
LOAD *,
INTERVAL(MAKETIME(18,0,0)-time) as time_diff;
LOAD *,
TIME(FRAC(timestamp_field)) as time;
LOAD
TIMESTAMP(TIMESTAMP#(timestamp_field,'DD/MM/YYYY hh:mm:ss')) AS timestamp_field
INLINE [
timestamp_field
10/11/2019 12:53:14
10/11/2019 13:41:10
10/11/2019 17:17:53
]
;
It works!
Thanks a lot!