From: Peter Garner <peter_garner@yahoo.com>
To: webmaster@retep.org.uk
Cc: pgsql-interfaces@postgreSQL.org
Subject: ResultSet.getDate
Date: Sat, 30 Jan 1999 22:31:32 -0800 (PST)
Message-ID: <19990131063132.26328.rocketmail@send205.yahoomail.com> (raw)
Hi Peter! ;-)
I think I may have found a problem in the postgres
JDBC driver V6.4. (BTW I assume the one I build from
the released source in postgresql-6.4.2.tar.gz is the
same as the jdbc6.4.jar downloadable from your web site
at http://www.retep.org.uk/postgres ? In anycase, the
problem seems to occur with both.)
Anyway I get an SQLException (well a parse exception,
really), when attempting to use the ResultSet.getDate
methods. The exception messages are (I omitted the
portions of the stack trace through my code):
Bad Date Format: at 0 in Fri Jan 29 04:29:50 1999 UTC
at postgresql.ResultSet.getDate(ResultSet.java:408)
Indeed, "Fri Jan 29 04:29:50 1999 UTC" is how dates are
output from my postgres databases. I am useing Redhat
5.2 and postgres built from the above mentioned source
file. The date format that is being selected for the
date formatter (ResultSet.java, line #403) is
"MM-dd-yyyy"
Which is of course not what postgres sends. Also, in
looking at this code, it seems that the time portion
is being thrown away in ResultSet.getDate, I am not
sure if this is what is intended from looking at the
JDBC API documentation published by Sun.
==
Peace,
Peter
We are Microsoft of Borg, you will be assimilated!!!
Resistance is fut... ***BZZZRT*** THUD!!!
[General Protection Fault in MSBorg32.DLL]
Please contact the vendor for more information
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: peter_garner@yahoo.com, webmaster@retep.org.uk
Subject: Re: ResultSet.getDate
In-Reply-To: <19990131063132.26328.rocketmail@send205.yahoomail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox