Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Using tMap, I try to insert some data into a tOracleOutput.
I need to map one of date columns on the tOracleOutput as follow :
TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",TalendDate.formatDate("dd/MM/yyyy",TalendDate.getCurrentDate()).concat(" ").concat(row3.HOUR).concat(":00"),true)
where row3.HOUR is a string column from an input and represents hours (e.g "08:30").
The purpose of this mapping is to concatenate the current date (eg. 15/03/2016) with the hour component from the input flow row3 (eg. "08:30") and then insert this new date (15/03/2016 08:30) into the database table.
Unfortunately, date recorded in the database table is truncated : 15/03/2016 00:00:00 while expected is 15/03/2016 08:30:00.
The same mapping sent to a tLogRow component show the correct output.
I'll be thankfull for any help.
Rado.
new java.sql.Date(out1.DATE_DOC.getTime())