topic Re: coverting time in Talend Studio

coverting time

lmit — Wed, 14 Mar 2018 07:07:16 GMT

Hi All,

Am using tstatscatcher component, it has a column duration i want to calculate the end time from duration column how can i do it?

I searched in forum and tried with new java.util.Date(ColumnName) , but its not giving the correct date

for example if i have 4000 as input its giving output as "05:30:04.000" -- its adding IST how can i handle it.

Thanks in advance,

Lmit

Re: coverting time

vboppudi — Wed, 14 Mar 2018 15:42:46 GMT

Hi Lmit,

What is the expected output for 4000.

i am assuming expected output should be 4000 = 01:06:40, please conform.

Regards,

Re: coverting time

lmit — Thu, 15 Mar 2018 04:12:43 GMT

Thanks for your reply Veeranjaneyulu,

Yes your assumption is correct

to be more clear , i want to add moment and duration which will come from tstatscatcher component so that i can generate end time of a job.please find the attachment for the columns.my end time should be data and timestamp

Thanks,

lmit

endtime.jpg

Re: coverting time

hami1 — Thu, 15 Mar 2018 06:38:30 GMT

Hi,

If you have some knowledge on Java , you can try tJava Component and try to convert the seconds into the HH:mm:ss format. For your reference am providing you a sample code which will convert the seconds into HH:MM:ss time format.

        int seconds = 4000;
        int p1 = seconds % 60;
        int p2 = seconds / 60;
        int p3 = p2 % 60;
try{
        System.out.print("Input seconds:");
        p2 = p2 / 60;
        System.out.print( p2 + ":" + p3 + ":" + p1);
    }
finally
{
}

Thanks,

Hameed

Re: coverting time

vboppudi — Thu, 15 Mar 2018 14:40:04 GMT

Hi Lmit,

If you want to derive start and end time of job, you need derive it based two records from tstatscatcher.

If message_type begin means job start and message_type='end' means job end time.

The duration is not in seconds, its in milliseconds. If you want to caluclate start and end time using one record, you need to use message_type='end' record and substract duration from moment, so you will get start time of that process.

Regards,

Re: coverting time

lmit — Fri, 16 Mar 2018 03:19:50 GMT

Thanks for your replies,

when i was clearing observing the tstatcatcher records i noticed that the begin and end records have different timestamp, the time(moment column) in the end record can be consider as end time?

If you see in the attachment , for both records of same flow has a timestamp difference of one sec. so can i consider it as a end time of the job?

Thanks,

lmit

stat_endtime.jpg

Re: coverting time

hami1 — Fri, 16 Mar 2018 05:51:01 GMT

Yes lmit, you can consider this as the Job Execution duration as 1 Sec(Time taken to finish the Job).

Thanks,

skh