Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA02460 for ; Thu, 19 Aug 1999 08:06:33 -0400 (EDT) (envelope-from jon@it-konsulenterne.dk) Received: from mailhotel3.inet.tele.dk (mailhotel3.inet.tele.dk [193.162.153.182]) by trends.net (8.8.8/8.8.8) with ESMTP id HAA27341 for ; Thu, 19 Aug 1999 07:28:47 -0400 (EDT) Received: from it-konsulenterne.dk ([195.249.230.167]) by mailhotel3.inet.tele.dk (Netscape Mail Server v2.02) with ESMTP id AAA17046; Thu, 19 Aug 1999 13:26:03 +0200 Sender: jon@trends.net Message-ID: <37BBE935.359F6DDE@it-konsulenterne.dk> Date: Thu, 19 Aug 1999 13:23:33 +0200 From: Jon Bundesen X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org, jon@it-konsulenterne.dk Subject: What JDBC datatype can be used for DATETIME ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm trying to read a DATETIME field from my Pg 6.4.2 using JDBC. When i try reading the date from my ResultSet using ResultSet.getDate() i get an error stating: java.sql.SQLException: Bad Date Format: at 0 in Thu Aug 19 12:19:52 1999 CEST at postgresql.ResultSet.getDate(ResultSet.java:407) at TestDate.main(TestDate.java:32) When i try using ResultSet.getTimestamp() instead, i also get an error: java.lang.NumberFormatException: 1999 CEST at java.lang.Float.(Float.java) at postgresql.ResultSet.getTimestamp(ResultSet.java:455) at TestDate.main(TestDate.java:32) I CAN use getString(), but i guess the has to be a better way ? Can anyone help ? Best regards, Jon Bundesen. Here is the code if anyone is interested ============================ Table = foo +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | dt | datetime | 8 | +----------------------------------+----------------------------------+-------+ import java.sql.*; import java.sql.Date; public class TestDate { public static void main (String args[]) throws Exception { Connection con; Statement statement; PreparedStatement preparedStatement; ResultSet rs; // String url = "jdbc:postgresql:test1"; String url = "jdbc:postgresql://127.0.0.1:5432/test1"; Class.forName("postgresql.Driver"); con = DriverManager.getConnection(url, "jon", ""); con.setAutoCommit( false ); // statement = con.createStatement(); statement.executeUpdate("insert into foo values ( current_timestamp )"); con.commit(); statement.close(); // statement = con.createStatement(); rs = statement.executeQuery("SELECT * FROM foo"); while (rs.next()) { System.out.println("Result: " + rs.getTimestamp(1)); } rs.close(); statement.close(); // con.close(); } }