JDBC: timezone difference except with getdate()

brlewis at alum.mit.edu brlewis at alum.mit.edu
Fri Oct 22 14:08:23 EDT 1999


I'm using the JDBC driver with MSSQL 6.5.  When I retrieve a datetime
column from a table, the dates are handled as if the server were
sending them in GMT, and are thus off 4 or 5 hours.  However, getdate()
is handled differently and has the correct time.

Is there some generic way to get the correct value from a datetime
without knowing whether it comes from getdate() or from table data?

-- 
Bruce R. Lewis			<URL:http://web.mit.edu/brlewis/www/>



More information about the FreeTDS mailing list