tFileOutputExcel date format issue

[Anonymous]

Hi All,

I have an oracle table which have two columns of date format. When i pull the data from Db to Excel those are shown as -1. The code is working fine in my local DB, but when i deploy it in Unix machine im facing this issue. Can you anyone help me with this

[Anonymous]

Hello,

Did you deploy your Job on Talend Runtime to retrieve data from your database? Are you referring to this related scenario:TalendHelpCenter: Scenario: Deploying your Job on Talend Runtime to retrieve data from a MySQL datab...?

In advanced settings of tfileoutputexcel component, have you tried to set the "Encoding" as UTF-8 to see if  it works?

Best regards

Sabrina

[Anonymous]

Hi Sabrina,

I have checked the encoding  UTF-8 but still it doesn't work.

Thanks,

Vanitha

[Anonymous]

Hello,

What's the locale encoding of your unix server?

If the project starts with the -Dfile.encoding=UTF-8 set, try to change the locale encoding to UTF-8.

Best regards

Sabrina