How to change default date format (dd-MM-yyyy) in Talend Open Studio 6.3

[tale103108]

Is there a way to change the default date format (dd-MM-yyyy) in Talend Open Studio 6.3.0 to something else? 

Cheers!

[cterenzi]

I have a similar, more general question. Is it possible to change the default values employed in a number of places by Talend?

[vapukov]

https://jira.talendforge.org/browse/TUP-16975

it is just 7.5 years from request! 🙂

as You can see - status still New 🙂 just 3-4 years more and could be done!

[Anonymous]

It can be done in latest 7.2 and 7.3 version:

Got to Studio/File/Edit project settings, find General/Medadata of TalendType.

Edit mapping_yourDB.xml per below. e.g.

<dbType type="DATE" ignoreLen="true" ignorePre="true" defaultPattern="dd-MM-yyyy" />

<dbType type="TIMESTAMP" ignoreLen="true" ignorePre="true" defaultPattern="yyyy-mm-dd hh:mm:ss.SSSSSS"" />

[CR1604353895]

Hi @Xin LIU​ ,

That worked clean, just have followup questions, Are these settings persistent? where are these settings saved in the backend? like if I want to open from file explorer, also are these project specific?

Thank you, I am looking for this info for a long time.