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:
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
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)
[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]
