date data type conflict

Highlighted
Six Stars

date data type conflict

Please see the data, job screen shot and output given in the pictures. And please tell why year is not coming properly. Out coming in the tlogrow.

Eight Stars

Re: date data type conflict

Because deafault format for date type is different in oracle.
https://i.stack.imgur.com/b1Qsa.png

You can try using TO_DATE(TO_CHAR(RESOLVE_DATE, 'DD-MON-YYYY'), 'DD-MON-YYYY') in your tOracleInput Query.
Six Stars

Re: date data type conflict

While loading the data in db I used Talend job only. With date format "yyyy-MM-dd'T'HH:mm:ss". Used timestamp  Oracle datatype to store that. Why it got stored like that as shown in pic in DB. 

 

Thanks for your suggestion. Will appreciate if you suggest solution that can use in tmap.

Eight Stars

Re: date data type conflict

While we view a date/timestamp field with sql developer ,it is default formatted and shown to us,no matter which format it got loaded.
You should change the NLS setting in db. Reffer below screenshot.
https://i.stack.imgur.com/b1Qsa.png

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read