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.
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.
1 select count(*)
2 from dba_tab_columns
3 where data_type='DATE'
4* and owner in ('SOURCE', 'TARGET')
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables