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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>