SQLTeam.com | Weblogs | Forums

Handling high value DATE in SQL

I am getting a -181 while checking the SQLCODE to high values

when sqlCode = SQL_SUCCESSFUL;
if accExpDt >= currentDate
process
else
Account invalid

Account expiry date is 9999-12-31 (which is high value ) getting an error -181

Handling this exception for high values is appreciated.

What data type is accExpDt

Is this microsoft sql server product?

Please provode some more context.
Isnthis as400, db2, making call from java, what version etc

This is as400 making call from .net.

This is microsoft sql server forum but there might be someone that knows the answer. There are a lot of answers on google for this also.