topic Wrong interval between times in App Development

Wrong interval between times

DanaL — Fri, 07 Oct 2022 14:46:59 GMT

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!

Re: Wrong interval between times

RsQK — Sat, 08 Oct 2022 06:13:01 GMT

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

Re: Wrong interval between times

DanaL — Sat, 08 Oct 2022 09:21:23 GMT

It works!

Thanks a lot!