topic Re: Date Format in Talend Studio

Date Format

Anonymous — Tue, 04 Apr 2017 17:37:14 GMT

I have date column that contains dates like this 3/17/17 rather than 3/17/2017 and in the database the date is displayed like this 0017-03-17 00:00:00. In my tMap I have this:

row1.Actual_Sale_Date.equals("")?null: TalendDate.parseDate("MM/dd/yyyy",row1.Actual_Sale_Date)

Even though I have the format defined as "MM/dd/yyyy" the database shows timestamp without time zone and the dates are
2017-03-17 00:00:00. I want to display 03/17/2017 in database.
Please kindly offer assistance.
Thanks in Advance,
John Doe

Re: Date Format

cterenzi — Tue, 04 Apr 2017 17:49:58 GMT

Dates are not Strings. The printed format of a date is not indicative of how it is stored. If you want a date to print a certain way, you have to format it. If your database offers multiple date types, maybe a different one would better suit your purposes? MySQL, for example, has DATE, DATETIME and TIMESTAMP, among others. ( https://www.tutorialspoint.com/mysql/mysql-data-types.htm)

Re: Date Format

Anonymous — Tue, 04 Apr 2017 17:50:33 GMT

Thanks I am using postgreSQL and just interested in plain Date format.

Re: Date Format

Anonymous — Tue, 04 Apr 2017 19:29:15 GMT

[font=consolas, monaco, bitstream vera sans mono, courier new, courier, monospace] first argument is source pattern and as your are getting in yy format in year, u can change as below and try.[/font]
[size=2][font=consolas, monaco, "bitstream vera sans mono", "courier new", courier, monospace]row1.Actual_Sale_Date.equals("")?null: TalendDate.parseDate ("MM/dd/yy",row1.Actual_Sale_Date) .[/font][/size]