Skip site navigation (1) Skip section navigation (2)


From: Peter Garner <peter_garner(at)yahoo(dot)com>
To: webmaster(at)retep(dot)org(dot)uk
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: ResultSet.getDate
Date: 1999-01-31 06:31:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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 ?  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(

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 (, line #403) is


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.


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
Get your free address at


pgsql-interfaces by date

Next:From: Peter GarnerDate: 1999-01-31 06:36:51
Subject: Re: ResultSet.getDate
Previous:From: yusuf GDate: 1999-01-31 01:26:38

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group