Thanks Jeff,
Hmmmm, I am a bit confused, again.
I went searching for the correct postgres jdbc driver, and don't know
exactly where to get the last version and source (I thought I did).
I seached on http://jdbc.postgresql.org/download/ but is that the correct
site ? and where can I get the source as I can't find it.
I searched on
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/interfaces/jdbc/, but
there I only have a complete three and don't realy know what to download.
Regards,
Ed Bras
----- Original Message -----
From: Jeff Schnitzer <[EMAIL PROTECTED]>
To: Orion-Interest <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 8:08 PM
Subject: RE: bad timestamp confusion
> Take a look at this message I posted in January:
>
> http://www.mail-archive.com/orion-interest@orionserver.com/msg08677.html
>
> If you patch the JDBC driver to read whatever format your dates are
> coming back as (you should see the actual formatted date string in the
> exception message), you should be ok.
>
> You might first check the CVS copy of the JDBC driver to see if it
> works; with any luck patches have already been made.
>
> Storing dates as strings just seems like a bad idea. It's nice to be
> able to do date math in SQL queries when you want to analyze your data.
>
> Jeff
>
> >-----Original Message-----
> >From: Eddie [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, March 21, 2001 4:55 AM
> >To: Orion-Interest
> >Subject: bad timestamp confusion
> >
> >
> >Just like other people in the newsgroup, I am receiving a bad timestamp
> >error once in a while with Postgres 7.0.
> >
> >I looked in the newsgroup and saw some possible solutions, but
> >I am a bit
> >confused.
> >How can I solve this problem for ever in case of a DateTime field ???
> >Someone talked about using java.sql.Date instead of java.util.Date, the
> >other about getting the last postgres jdbc driver....
> >I got the last postgres driver from the postgres site, so what
> >should I do
> >??
> >
> >I was thinking about just using Strings to store Date format info. What
> >about this ?
> >
> >And what should I do when I get such an error. Filling the
> >database all over
> >again helps. But what, when I have everyting ready online ??
> >
> >Regards,
> >Eddie
> >
> >
>
>
