topic Re: DateTime sepration tmap to Mysql Workbench in Talend Studio

DateTime sepration tmap to Mysql Workbench

Anonymous — Sun, 10 Mar 2019 13:11:48 GMT

Hello,

I have been trying to delete time from DateTime String to Date format "yyyy-MM-dd" using tmap component.

My components are: tFileInputDelimited to tmap to tLogRow to tMysqlOutput

When I excute the job there are no errors and in the tLogRow everything looks perfectly fine as I needed. However, I get the date format as "yyyy-MM-dd hh:mm:ss" instead of "yyyy-MM-dd" in the final output which is tMysqlOutput (in my case am using Mysql Workbench).

I have used the expression : TalendDate.parseDate("yyyy-MM-dd",row1.Date)

IMAGES ATTACHED

Thank you for helping guys,

Sherif

Re: DateTime sepration tmap to Mysql Workbench

akumar2301 — Sun, 10 Mar 2019 14:09:34 GMT

what is datatype of column in database ? is it date , datetime or timestamp? if it is not date type , it will display timestamp.

Re: DateTime sepration tmap to Mysql Workbench

Anonymous — Mon, 11 Mar 2019 05:49:25 GMT

Hi,

This looks like the data's timezone is getting changed by 1 hour while loading to MySQL server.

Could you please try to load the date column where your timezone is explicitly mentioned in the output of tMap?

It may resolve the issue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂