DSXchange

I'm facing an issue with the result of Date Conversion function .

I processed the same input file in different servers .In one server i'm having a version Datastage 7.5.1 .And another server i'm using Datastage 7.5.2 . But i'm getting diferent ouptut values for one of the field (DAY_OF_WEEK )

In the Transformer we are having the below function.
Oconv(Iconv(to_trans_juliandate.INV_DATE_JUL, "DYJ"), "DW")

Will these DateConverison functions results differenent values for Differen versions of datastage . (7.5.1 and 7.5.2 )

For Example ::
The INV_DATE_JUL column contains the 2009326 value . After applying the above function it gives output value as 1 in server having datastage version 7.5.2 and 7 in another server.

Could you please help me in getting the correct output value.

This is not a QualityStage question.

**Note - topic relocated by Content Editor **

Hi All,

Any thoughts for my DateConversion issue

This is not a QS question but ...... both output are correct ... nothing wrong with the Iconv/Oconv function

Looks like one of your server (result 1) is having NLS enable where Sunday is the first day of the week. The other server ( result 7 ) is not having NLS enable and Monday will be the first day of the week hence Sunday will result in weekday number 7

If you want to have same results disable the NLS functionality for the Date/Time locale. Job property --> NLS page --> Date /Time = OFF

Thanks a lot julio . It's working fine now..

Then please mark your post as Resolved using the button at the top of the page.