From: | Jon Bundesen <jon(at)it-konsulenterne(dot)dk> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org, jon(at)it-konsulenterne(dot)dk |
Subject: | What JDBC datatype can be used for DATETIME ? |
Date: | 1999-08-19 11:23:33 |
Message-ID: | 37BBE935.359F6DDE@it-konsulenterne.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.<init>(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();
}
}
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-08-19 13:16:30 | Re: [SQL] Problems using count() with a join |
Previous Message | tjk@tksoft.com | 1999-08-19 05:20:36 | Re: [SQL] Counting the number of distinct rows returned |