I have a query with no parameters that runs perfectly when I start it from my DBclient (Squirrel). The problem is that when an application deployed on JBoss tries to run this query. I receive the following message:
"The conversion of a char data type to a DATETIME data type resulted in an out-of-range DATETIME value".
How can this be resolved?