Message-ID: <001401bf3918$4ec820c0$a778ebc3@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <E11rhzG-0002Np-00@quartz.newn.cam.ac.uk>
Subject: datetime, JDBC, and MS Access
Date: Sat, 27 Nov 1999 21:44:44 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi:
Probably someone of you can tellme what am I doing wrong:

I create a table in psql, with an unique column of the type "date" wich name
is "columdate".
Then, via JDBC, I try to put the content of that column in a Java Date
object. OK, no problem. I write this:

Date mydate=rs.getDate("columndate");

Now I can operate with mydate normaly.

But the PROBLEM is when in psql, the column "columndate" is of the type
"datetime". In that case, the java sentence puts null to mydate.

Why as "date" works and as "datetime" it doesn't work?

If also tried this:
Timestamp mydate=rs.getTimestamp("columndate");

but it doesn't work.

I would define de column as "date" the problem is solved, but, you know, the
tables are created exporting them from MS Access via ODBC, and when exported
so, postgresql converts to "datetime" all columns that in MS Access were of
the type "Date/Hour".

I could get my problem solved if some of you knows how to tell Access to
export "Date/Hour" types to postgresql "date" in side of  "datetime".

Thank you very much.