topic time difference in Talend Studio

time difference

Anonymous — Sat, 16 Nov 2024 12:36:16 GMT

Hi,
I would like to find time dfference between dbinput and current timestamp. I want the difference in minuts.
My timestamp column in dbinput is date.
I am wondering how I can do it in talend.
Thanks.

Re: time difference

Anonymous — Mon, 24 Oct 2011 02:23:48 GMT

Hi
Using the built-in function, TalendDate.diffDate(Date date1, Date date2, String dateType), it return a long type, for exmaple:
TalendDate.diffDate(row1.mydate, TalendDate.getCurrentDate(),"mm")
Best regards
Shong

Re: time difference

AmrapaliPatil — Fri, 12 Jul 2019 18:18:07 GMT

@shong This doesn't work if we want the difference in minutes i.e. "mm" format.

Re: time difference

Anonymous — Thu, 18 Jul 2019 11:02:30 GMT

@AmrapaliPatil
I just made a simple testing and I can confirm the function TalendDate.diffDate can get the difference in minutes. About your issue, I guess your timestamp data does not contains the time part, can you show an example what the dbinput component read from db?
Can you have a try to change the data type to datetime and test again?

Regards
Shong