topic Re: Timestamp difference in QlikView

Timestamp difference

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

I have two timestamp fields JOB_CREATE and JOB_ONSITETIME

in the script, I need to calculate a new field JOB_RESPONSE in minutes calculated using JOB_ONSITETIME - JOB_CREATE

for eg: 12/29/2016 00:12:20 - 12/29/2016 00:12:16 = 0.04 SECONDS CONVERT TO MINUTE AS 00

I have used the following in script and got the output as:

Num(Timestamp(JOB_ONSITETIME,'MM/DD/YYYY HH:MM:SS')-Timestamp(JOB_CREATETIME,'MM/DD/YYYY HH:MM:SS')) as JOB_RESPTIME

Output as:

which must be 0.04

I need to develop in the script wise, can anyone help me,

regards,

Yoganantha Prakash G P

Re: Timestamp difference

Anil_Babu_Samineni — Thu, 29 Jun 2017 17:33:24 GMT

May be use this?

Hour(Timestamp(JOB_ONSITETIME,'MM/DD/YYYY HH:MM:SS')-Timestamp(JOB_CREATETIME,'MM/DD/YYYY HH:MM:SS'))

Inteval(Timestamp(JOB_ONSITETIME,'MM/DD/YYYY HH:MM:SS')-Timestamp(JOB_CREATETIME,'MM/DD/YYYY HH:MM:SS'),'HH')

Time(Timestamp(JOB_ONSITETIME,'MM/DD/YYYY HH:MM:SS')-Timestamp(JOB_CREATETIME,'MM/DD/YYYY HH:MM:SS'),'HH')

Re: Timestamp difference

Anonymous — Thu, 29 Jun 2017 18:14:56 GMT

Try This one.

INTERVAL(JOB_ONSITETIME - JOB_CREATE,'SEC')

Re: Timestamp difference

MarcoWedel — Fri, 30 Jun 2017 22:58:04 GMT

Hi,

maybe like this?

LOAD *,
     Interval(JOB_ONSITETIME-JOB_CREATETIME, 'm.ss') as JOB_RESPTIME
INLINE [
    JOB_CREATETIME, JOB_ONSITETIME
    12/29/2016 00:12:16, 12/29/2016 00:12:20
];

hope this helps

regards

Marco