freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: joel_trunick AT dell.com
- To: freetds
- Subject: Reading DateTime in MSSQL (6.5) - BUG?
- Date: Wed, 21 Apr 1999 11:28:40
When reading dates in MSSQL, I consistently get a time 5 hours earlier than
what is in the database. Is the code wrong, or is this a bug?
-------------------
String sql = new String("Select max(ModTime) from FileJournal");
try {
Connection conn = Connect.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery( sql );
if ( rs.next() )
ts = rs.getTimestamp(1); //"ModTime"
System.out.println( ts ); //5 hours less than ISQL!
...
-
Reading DateTime in MSSQL (6.5) - BUG?,
joel_trunick, 04/21/1999
- <Possible follow-up(s)>
- Re: Reading DateTime in MSSQL (6.5) - BUG?, Craig Spannring, 04/21/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, joel_trunick, 04/21/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, Craig Spannring, 04/21/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, joel_trunick, 04/22/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, joel_trunick, 04/22/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, Craig Spannring, 04/27/1999
- Re: Reading DateTime in MSSQL (6.5) - BUG?, joel_trunick, 01/29/2024
Archive powered by MHonArc 2.6.24.