The stranger thing is that it doesn't throw an exception on the update; but
when you requery the field. The driver sets the timestamp into the field,
then says, it doesn't like the format of the timestamp. Odd. I guess if
I'm serious about this I'll have to grab the source for the driver and take
a look. I don't want to modify my peer code for an odd ball behavior in the
driver.
> on 5/21/2000 7:58 AM, Nissim <[EMAIL PROTECTED]> wrote:
>
> > When sending timestamps to PGSL, you have to do this:
> >
> > SimpleDateFormat df = new SimpleDateFormat("EEE MMM dd hh:mm:ss.S yyyy
> > z");
> > sql.append("WHERE dateField =
> > '").append(df.format(someJavaDate)).append("'");
> >
> > That's for the default date formatting on the servet. You can also
> > change that format on the server, but I don't know how.
> >
> > -Nissim
>
> The driver won't accept a new java.util.Date() or java.sql.Date() objects
> and do the right thing?????
>
> That is stupid.
>
> -jon
>
> --
> Java Servlet Based - Open Source | Collab.Net
> Bug/Issue Tracking System | now hiring smart people
> <http://scarab.tigris.org/> | <http://Collab.Net/jobs/>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
