Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA94686 for ; Fri, 20 Aug 1999 02:49:04 -0400 (EDT) (envelope-from echiner@tissat.es) Received: from tissat.es ([195.77.30.15]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA46AF; Fri, 20 Aug 1999 08:48:31 +0200 Message-ID: <37BCF9E6.403A5EA8@tissat.es> Date: Fri, 20 Aug 1999 08:47:03 +0200 From: "Esteban Chiner Sanz" X-Mailer: Mozilla 4.5 [es] (WinNT; U) X-Accept-Language: es MIME-Version: 1.0 To: Jon Windfeld Bundesen CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] What JDBC datatype can be used for DATETIME ? References: <37BC25CD.DB267B3F@it-konsulenterne.dk> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I had the same problem and I finally ended up using the timestamp type in postgres and using the getTimestamp function y Java. That worked fine for me. Esteban Chiner Jon Windfeld Bundesen escribió: > 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(); > } > } > > ************ ------------------------------------------------------------ Esteban Chiner Sanz mailto (work): echiner@tissat.es TISSAT Av. Aragon, 30, 5ª planta Phone: 96 393 9950 Valencia (SPAIN)