Re: [INTERFACES] Re: ResultSet.getDate - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] Re: ResultSet.getDate
Date
Msg-id Pine.LNX.4.04.9902050655300.22685-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [INTERFACES] Re: ResultSet.getDate  (Aleksey Demakov <avd@gcom.ru>)
List pgsql-interfaces
On 2 Feb 1999, Aleksey Demakov wrote:

> Peter Garner <peter_garner@yahoo.com> writes:
>
> > I am using the JDK 1.1.7v1a from Blackdown.  Indeed,
> > Java's handling of dates is a little funky.  But in
> > this case the problem is that the returned strings
> > are not being handled properly.  Calling getString
> > instead of getDate returns :
> >
> > "Mon Feb 01 16:08:00 1999 UTC"
> >
> > And the format string used in the SimpleDateFormatter
> > object that getDate uses to convert that string is
> > not correct for that format.  If there is anything I
> > can do to help, please let me know! :-)
>
> Perhaps opening your connections as follows might help you
>
> ...
>     // open connection
>     conn = DriverManager.getConnection (url, usr, pwd);
>
>     // set datestyle
>     Statement st = conn.createStatement ();
>     st.executeUpdate ("set datestyle='iso'");
>     st.executeUpdate ("show datestyle");
>     st.close ();

I'm thinking on doing this within the driver, forcing it to use iso all
the time.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


pgsql-interfaces by date:

Previous
From: "Stephen Turner"
Date:
Subject: Help with ODBC Driver
Next
From: Peter T Mount
Date:
Subject: Re: [INTERFACES] Re: ResultSet.getDate