Exception: Bad Timestamp Format at 0 in 'now' - Mailing list pgsql-novice

From Gavin Henry
Subject Exception: Bad Timestamp Format at 0 in 'now'
Date
Msg-id 47220.195.38.86.72.1131554642.squirrel@webmail.suretecsystems.com
Whole thread Raw
List pgsql-novice
Dear List,

We are having problems with pg74.215.jdbc3.jar and Postgresql-7.4.8

We are using Open-Xchange (raised this question there, and we both checked
this error using below) and keep getting this "Bad Timestamp" error. Just
to confirm, we ran:

openexchange=> SELECT date('now') as usedformat;
  usedformat
 ------------
  2005-11-08
 (1 row)

 openexchange=> SHOW DateStyle;
  DateStyle
 -----------
  ISO, MDY
 (1 row)

Which suggests we shouldn't be getting this error.

Any other debugging tips?

Many thanks,

Gavin.

--
Kind Regards,

Gavin Henry.

Open Source. Open Solutions(tm).
http://www.suretecsystems.com/



pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Dump/restore needed from 8.1b1 to 8.1.0?
Next
From: David Orme
Date:
Subject: Using values in an array in a subquery