Thread: Exception: Bad Timestamp Format at 0 in 'now'

Exception: Bad Timestamp Format at 0 in 'now'

From
"Gavin Henry"
Date:
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/