Date Pattern is missing time elements for Oracle DATE column

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.