DateTime sepration tmap to Mysql Workbench

[Anonymous]

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

[akumar2301]

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

[Anonymous]

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 🙂