Received: from ns.gcom.ru (Garant-Siberia-PostOffice.gcom.ru [194.84.180.33])
	by hub.org (8.9.2/8.9.1) with ESMTP id XAA03899
	for <pgsql-interfaces@postgresql.org>;
	Mon, 1 Feb 1999 23:24:03 -0500 (EST) (envelope-from avd@avd.gcom.ru)
Received: (from uucp@localhost) by ns.gcom.ru (8.6.10/8.6.10) id KAA21418 for
	<pgsql-interfaces@postgresql.org>; Tue, 2 Feb 1999 10:23:44 +0600
Received: from avd.gcom.ru(194.84.180.53)
	via SMTP by Garant-Siberia-PostOffice.gcom.ru, id smtpd021415;
	Tue Feb  2 10:23:40 1999
Received: (from avd@localhost) by avd.gcom.ru (8.8.8/8.8.8) id KAA01640;
	Tue, 2 Feb 1999 10:39:21 +0600 (NS) (envelope-from avd)
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Re: ResultSet.getDate
References: <19990201214348.22907.rocketmail@send202.yahoomail.com>
From: Aleksey Demakov <avd@gcom.ru>
Date: 02 Feb 1999 10:39:20 +0600
In-Reply-To: Peter Garner's message of Mon, 1 Feb 1999 13:43:48 -0800 (PST)
Message-ID: <871zk9zafb.fsf@avd.gcom.ru>
Lines: 31
X-Mailer: Gnus v5.5/Emacs 20.2

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

-- 
Aleksey Demakov
avd@gcom.ru