topic Issue in converting Date format yyyy to int in Talend Studio

Issue in converting Date format yyyy to int

Anonymous — Mon, 04 Jun 2018 05:13:11 GMT

There is a mySQL variable in "YEAR" datatype i.e. present in "yyyy" and I would like to convert it as int through Talend.

I use tMap with expression function formatDate to convert the type as str and then use tConvertType compo to convert the str as int. When I look up the result by tLogRow. the variable is unable to represent with error java.text.ParseException: Unparseable date: "2004". How can I solve the issue?

Re: Issue in converting Date format yyyy to int

David_Beaty — Mon, 04 Jun 2018 09:39:26 GMT

Assuming you have the correct syntax of TalendDate.formatDate(), are you sure the year column is on the database as a date type and the schema within Talend is a date time?

Thanks

David

Re: Issue in converting Date format yyyy to int

Anonymous — Tue, 05 Jun 2018 05:02:51 GMT

Check to make sure the input is a valid date format then use.

TalendDate.getPartOfDate("YEAR",yourdate)

This returns an INT type without the need of the tconverttype