Wrong interval between times

[DanaL]

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!

[RsQK · Accepted solution]

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
]
;

[DanaL]

It works!

Thanks a lot!