Four Stars

tFileOutputExcel date format issue

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

3 REPLIES
Moderator

Re: tFileOutputExcel date format issue

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tFileOutputExcel date format issue

Hi Sabrina,

 

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

 

Thanks,

Vanitha

 

 

 

Moderator

Re: tFileOutputExcel date format issue

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.