What JDBC datatype can be used for DATETIME ?

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();
}
}

Browse pgsql-sql by date

  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