topic Re: [resolved] Adding 2 Dates in Installing and Upgrading

[resolved] Adding 2 Dates

lmit — Sat, 16 Nov 2024 11:23:11 GMT

Hi,
I want to add 2 dates which are coming in my input along with time.
My Input is
2015-02-26 08:00:00 1900-01-01 09:00:00

My Output should be
2015-02-26 17:00:00
In my output my date should be same which is coming from first column.
Thanks In advance
Lmit

Re: [resolved] Adding 2 Dates

Anonymous — Wed, 17 Dec 2014 02:39:22 GMT

Get respectively the hours, minutes and seconds of the second date, for example,
tFileInputDelimited--main--tJavaRow--main--tMap....
on tJavaRow

context.hours=row1.secondColumnName.getHours();
context.minutes....

Then, add hours, minutes and seconds to the first date using built-in function on tMap, for example:

TalendDate.addDate(row1.firstColumnName,context.hours,"HH")

Best regards
Shong

Re: [resolved] Adding 2 Dates

lmit — Thu, 18 Dec 2014 07:05:12 GMT

Thanks for your reply Shong...I need to consider Minutes and Seconds also.how can i get it?
My Input
2015-02-26 08:20:00 1900-01-01 09:40:00
Output
2015-02-26 17:60:00.
Minutes and seconds also need to get added
Thanks In Advance
Lmit

Re: [resolved] Adding 2 Dates

Anonymous — Mon, 22 Dec 2014 10:45:52 GMT

Hi Lmit,
Try the following approach:
1. Separate the 2 dates to be added; the 1st one would be of the format "yyyy-MM-dd HH:mm:ss" & the 2nd one of "HH:mm:ss"
2. Now extract the Hour, Minute & Seconds part from the 2nd date, & convert it to Integer format.
3. Then use something like this:

TalendDate.addDate(TalendDate.addDate((TalendDate.addDate(Var.base_time,"yyyy-MM-dd HH:mm:ss",Var.tobeadded_time_hh,"HH")),"yyyy-MM-dd HH:mm:ss",Var.tobeadded_time_mm,"mm"),"yyyy-MM-dd HH:mm:ss",Var.tobeadded_time_ss,"ss")

This would add Hours, as well as Minutes, as well as Seconds.
Hope this should work for you.
MathurM

Re: [resolved] Adding 2 Dates

Anonymous — Mon, 22 Dec 2014 10:49:30 GMT

I performed the whole operation in a tMap (you can work with any other component of your choice)
The following is the output