Stored Procedure Date issue
Posted: 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.
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.