Stored Procedure Date issue

anupam · Post by **anupam** » Mon Dec 29, 2008 2:42 am

Hi,

My job is executing one stored procedure (using stored procedure stage). this SP takes date as an input and date_out as an output. The procedure is running fine but the issue is that the output date is not correct.

For eg, Its giving 01-JAN-2000 as an output where as the output should be 01/01/1900. I have checked it in TOAD with the same parameter, there its showing the output as 01/01/1900 but when its comig out of datastage, its changing the year to 2000 instead or 1900.

Please suggest.

ArndW · Post by **ArndW** » Mon Dec 29, 2008 5:48 am

My guess is that you are not supplying a full 4 digit year in the returned value, and DataStage is using the setting of $APT_DATE_CENTURY_BREAK_YEAR to interpret that date as 2000 instead of 1900.