Date Pattern is missing time elements for Oracle DATE column

Highlighted
Four Stars

Date Pattern is missing time elements for Oracle DATE column

I'm new to Talend Open Studio for Data Integration (7.0.1).  I noticed when I add tables via Retrieve Schema, the Date Patterns are all set to "dd-MM-yyyy".  I would expect this would truncate the date causing loss of time information.  I really don't want to hand-edit all of these for every table/column and the chances of errors/omissions are high.  Is there any way to specify the default pattern?  Would need it to apply to all schemas within the Db Connection.  I was unable to find it in Preferences.

Moderator

Re: Date Pattern is missing time elements for Oracle DATE column

Hello,

It is not possible to register another custom Date pattern in the list.

We have to select an existing one and modify it each time.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Date Pattern is missing time elements for Oracle DATE column

Yikes...

 

1 select count(*)
2 from dba_tab_columns
3 where data_type='DATE'
4* and owner in ('SOURCE', 'TARGET')
SQL> /

COUNT(*)
----------
2413

Compared to all other datatypes, this is 10% of the columns in the two schemas

 

Perhaps consider to make the default date pattern to contain time elements or establish a new preference.

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch