topic Re: Combine Columns Date and Hours in Talend Studio

Combine Columns Date and Hours

Anonymous — Sat, 16 Nov 2024 06:37:39 GMT

Hi friends, good morning! I would like to know how do I combine two columns, one of date and another of houras in the talend and import into the database the date format time?

Ex: Column DataRef: 11/02/2019 and column hour string: 10:22:03, I would like to save the following column in the db 11/02/2019 10:22:03 ?

Thanks !

Re: Combine Columns Date and Hours

fdenis — Mon, 11 Feb 2019 11:14:44 GMT

hi, the best way for me it's to format date and time to string. concatenate them then retrive datetime from this string.

if columns came from db you can do it on db side

an other way is to merge date and time in sql using tDbRow and an insert query.

good luck

Re: Combine Columns Date and Hours

Anonymous — Mon, 11 Feb 2019 11:24:19 GMT

This very much depends upon the column types you are combining and the column type you want to output. If they are Strings and you want to output in a String column, you simply need to concatenate using something like this....

row.DateColumn +" " +row.TimeColumn

....in your output column in a tMap.

Otherwise, it might take a little more than that, but it still won't be too difficult.

Re: Combine Columns Date and Hours

Anonymous — Mon, 11 Feb 2019 11:26:24 GMT

Sorry for jumping in @fdenis. I started responding before you posted and left the response window while I had a call. Seems like you can handle this one 🙂

Re: Combine Columns Date and Hours

fdenis — Mon, 11 Feb 2019 13:06:19 GMT

@rhall no problems.

Re: Combine Columns Date and Hours

Anonymous — Tue, 12 Feb 2019 10:09:10 GMT

Hi You can use tJavaRow components and use below logic

output_row.Date = input_row.Date; // it is string datatype
output_row.Hours = input_row.Hours; // it is string datatype
output_row.Date_hours = TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",input_row.Date+" "+input_row.Hours);

and in output oracle use timestamp datatype of your required date .

Thanks,

Dhanraj

Date.PNG