assigning ResultSet.getDate()

I am using ResultSet.getDate() to get a date field from MSSQL Server database. What variable type do I best assign the returned value to? getDate() returns a java.sql.Date object.I need to adjest date to account for time zone differences then return adjusted date to dbase.

Have tried

java.sql.Date cDate = rs.getDate("CDateTime");

CDateTime is the name of the field in dbase, but I get an

error thrown at this line as:

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index

Would appreciate any comments on best way to assign rs.getDate().

Any comments on why this error is thrown? I have double checked that field name used is correct.

[729 byte] By [tully4] at [2007-9-26 2:50:33]