Convert date to Timestamp

ssarma1625980935 — Fri, 15 Nov 2024 23:58:03 GMT

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.

Re: Convert date to Timestamp

Anonymous — Mon, 12 Jul 2021 04:57:16 GMT

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

topic Convert date to Timestamp in Talend Studio

Convert date to Timestamp

Re: Convert date to Timestamp