please display the SQL or Java Statement which constructs the incorrect date thanks, Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Wed, 17 Sep 2008 18:27:40 -0700 > From: warren@xxxxxxxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] Bad Timestamp Format at 23 in ... > > I have Postgresql 8.3 (PostgresPlus) running on an Apple with Tomcat 6. > I am using the postgresql-8.3-603.jdbc3.jar driver. My app runs fine > when on the apple, but when I move it over to a Windows machine running > Tomcat 6 that accesses the same exact database on the Apple I get a "Bad > Timestamp Format at 23 in 2008-09-16 18:41:00.479" error. I am guessing > that it has something to do with how Java creates Dates on Unix verses > Windows. Is this a JDBC issue or is there something I need to do in > Postgres to make this work? > > -- > Thanks, > > Warren Bell > 909-645-8864 > warren@xxxxxxxxxxxxxxxxxxx > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie. Learn Now |