Hi,

The date in the database is being stored in MM/DD/CCYY format, but when my SP is trying to retireve it into a cursor and send it to the front end, the output date is returned in CCYY-MM-DD format.
My current DB2 v7.1 was working as desired, now it is has been upgraded to DB2 v8.1. Can it be an issue of DB version?

Thanks,
Indresh