Casting date in Talend Data Integration

date casting bigdata talend data-integration
Paul Maclean picture Paul Maclean · May 21, 2013 · Viewed 13.8k times · Source

In a data flow from one table to another, I would like to cast a date.

The date leaves the source table as a string in this format: "2009-01-05 00:00:00:000 + 01:00".

I tried to convert this to a date using a tConvertType, but that is not allowed apparently. My second option is to cast this string to a date using a formula in a tMap component.

At the moment I tried these formulas:

- TalendDate.formatDate("yyyy-MM-dd",row3.rafw_dz_begi);
- TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row3.rafw_dz_begi);
- return TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row3.rafw_dz_begi);

None of these worked. When inserting the result into the target-table (MySQL, InnoDB) a receive the error message that the date is not valid. The format of the target field is a MySQL Date field.

How can I cast the date to the desired format?

Answer

Jean-Michel Garcia picture Jean-Michel Garcia · May 22, 2013

Talend offers you a nice way of handling date formats. You can easily change the date format in the Schema editor tab at the tMap window.

It works for both tMap input and output flows. I've added a picture for a better illustration.

enter image description here

Related questions

Android, How can I Convert String to Date?

I store current time in database each time application starts by user. Calendar c = Calendar.getInstance(); String str = c.getTime().toString(); Log.i("Current time", str); In database side, I store current time as string (as you see in above …

Read More
Hive cast string to date dd-MM-yyyy

How can I cast a string in the format 'dd-MM-yyyy' to a date type also in the format 'dd-MM-yyyy' in Hive? Something along the lines of: CAST('12-03-2010' as date 'dd-mm-yyyy')

Read More
SELECT CONVERT(VARCHAR(10), GETDATE(), 110) what is the meaning of 110 here?

When we convert or cast date in sql, see below sql code SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] it works fine, I just want to know the meaning of 110 in above code. what it does actually, sometimes we use 102, 112 etc. …

Read More