Toracleinput does not send to_char, To_date values

[Anonymous]

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)

[manodwhb · Accepted solution]

@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.