Convert date to Timestamp

[ssarma1625980935]

Hi All,

I have 10 date fields whose values like:

Column_A = 7/23/2021

Col_B=08/23/2021

Col_C= 08/23/2021 11:23:37 AM

All I am trying to do is, send these date columns from one (Oracle) input table which has string data type to (Oracle) target table which has TIMESTAMP data types.

For the fields Column_A, Col_B it has to put Timestamp automatically as 00:00:00

Please guide me, how can I do it.

Thanks in advance.

[Anonymous]

Hi

Read the source data with string type and convert it to Date type on tMap, set the date pattern of output column as "MM/dd/yyyy HH:mm:ss" and set the expression like this:

TalendDate.parseDate("MM/dd/yyyy",row1.Col_B)

Regards

Shong