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.
Stored Procedure Date issue
Moderators: chulett, rschirm, roy
Stored Procedure Date issue
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.