Toracleinput does not send to_char, To_date values

Anonymous — Sat, 16 Nov 2024 03:51:08 GMT

Hi Talend Community,

I calcuted the utc time using the following query in oracle

I get the following desired result in the toracleinput preview:

I configured the following schema for oracle( i dont send the stop_start_datetime/stop_end_datetime values)

I configured the following schema for the tlogrow

This is the result i get. As you can see the stop_start_utc/stop_end_utc. Doesnt get send.

My question is:

- Did i misconfigured the schema settings for toracleinput/tlogrow?

- Or is there something else im missing.

I used tlogrow as a test. For the endresult i would like to send those dates to a sql table (with the datetime datatype for the stop_start_utc/stop_end_utc)

Re: Toracleinput does not send to_char, To_date values

manodwhb — Thu, 12 Dec 2019 11:32:19 GMT

@henkiiee02 , keep the columns machine id ,sku id ,time columns in select is returning and keep those only in the tDBInput schema and populate those into tLogRow.

topic Re: Toracleinput does not send to_char, To_date values in Talend Studio

Toracleinput does not send to_char, To_date values

Re: Toracleinput does not send to_char, To_date values