Been going crazy here because a stupid DATE field when it coverts through JDBC to Java (no matter what the java type) it converts to the day before as something like 2001-08-26 23:59:59.997 when it should be something like 2001-08-27 00:00:00.000. Instead it converts back a day by about .003 seconds or so. (changing the jdbcType in my result map didn't help either.)
Anyway as Nathan pointed out (check is in the mail Nathan) it's probably a driver issue. I refused to believe him since I was using the latest jtds open source driver for Sybase. Sure enough if I go back to the jconn3 driver (not in maven that I can find by the way.. nice), things work. In case anyone cares, you can still use the latest jtds driver with this work-around in your sql if you do a covert. Stupid that I have to do it if you ask me: convert(DATETIME, bd.broadcastDate) Thanks for ruining my Friday Sybase. -- Rick
