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