You are not logged in.

#1 2011-03-17 12:59:15

janhess
Member
1296 posts

Metadata default date format

Is there any way in TIS 4.0.2 to change the defult metadata date format of dd-MM-yyyy? All my dates are in yyyy-MM-dd format from files and databases.

Offline

#2 2011-03-17 14:51:34

vladika
Member
47 posts

Re: Metadata default date format

When importing from plain txt source (tabdelimited, etc..) you have to match format as it is written inside the file you're about to import into job.

In schema editor, define the appropriate field as Date and double click on the date DatePattern and write down your format or just use CTRL+SPACE for suggestions.

For example, if your starting .csv file has date in numeric format: 17032011, you would write in DatePattern field in schema editor: "ddMMyyyy".

Once inside talend, you can just use the default format "dd-mm-yyyy". At the end of the flow:

1. If you're dumping data into say tabdelimited file, you can choose again the Date Pattern
2. if you're dumping the data into some database, there's no option to specify the date format. Database will use it's own.

Offline

#3 2011-03-17 15:30:58

janhess
Member
1296 posts

Re: Metadata default date format

I need to be able to change the default automatically generated date pattern so when I generate a table schema for a database I want the pattern as yyyy-MM-dd not dd-MM-yyyy. I don't want to have to change anything in the schema as there are dozens of date fields in the database.
I was hoping there would be something to change in the Talend preferences.

Offline

#4 2011-03-17 23:32:22

alevy
Member
1922 posts

Re: Metadata default date format

What DB are you using?  As vladika said, generally for a DB, a date is a date is a date.  It does not have a format as such.  The way dates are displayed by the DB is native to the DB and cannot usually be set at the field/table level.  So, when writing a Date to a DB, it does not matter what the Date Pattern is in Talend.  The Talend Date Pattern is only relevant when reading from/writing to flat-files.

Offline

#5 2011-03-21 10:37:15

janhess
Member
1296 posts

Re: Metadata default date format

I just want to be able to change the default so it applies to any date from anywhere!!

Offline

#6 2012-03-13 12:56:22

geuder
Member
112 posts

Re: Metadata default date format

I second janhess' request.

I also want to have the default date pattern "yyyy-MM-dd"

Is that possible?

Offline

#7 2012-04-12 17:04:50

eric_k
Member
2 posts

Re: Metadata default date format

We really need this option as well. 

I don't see why the mapping.xml file cannot have an attribute for default date pattern just like the other fields (length, precision, etc).

if you have a job that requires hundreds of patterns to be declared, it literally makes the product unusable.  You want to waste hours of an engineers time changing a text box when the UI could just default the value from your xml config.

Shameful.

Offline

#8 2012-06-07 12:41:34

emaxt
Member
325 posts

Re: Metadata default date format

up.
any news?
Talend should really include a customizable global/per-project/per-DBMS default datepattern.
Very much needed.
I see also an opened ticket:
http://jira.talendforge.org/browse/TDI-13550

Offline

#9 2012-06-07 13:03:41

shong
Talend Team


Re: Metadata default date format

Hi  All

I agree that it is an interesting and useful feature, our R&D team have known it.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

Board footer