Received: from mailhotel3.inet.tele.dk (mailhotel3.inet.tele.dk [193.162.153.182]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA58156 for ; Thu, 19 Aug 1999 11:44:38 -0400 (EDT) (envelope-from jon@it-konsulenterne.dk) Received: from it-konsulenterne.dk ([195.249.228.223]) by mailhotel3.inet.tele.dk (Netscape Mail Server v2.02) with ESMTP id AAA19670 for ; Thu, 19 Aug 1999 17:44:36 +0200 Message-ID: <37BC25CD.DB267B3F@it-konsulenterne.dk> Date: Thu, 19 Aug 1999 17:42:05 +0200 From: jon@it-konsulenterne.dk (Jon Windfeld Bundesen) X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org 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'd like to get a real Date object, not just a String. 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)); //System.out.println("Result: " + rs.getDate(1)); } rs.close(); statement.close(); // con.close(); } }