Exception: Bad Timestamp Format at 0 in 'now'

From: "Gavin Henry" <ghenry(at)suretecsystems(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Exception: Bad Timestamp Format at 0 in 'now'
Date: 2005-11-09 16:44:02
Message-ID: 47220.195.38.86.72.1131554642.squirrel@webmail.suretecsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-novice by date

  From Date Subject
Next Message David Orme 2005-11-09 17:39:02 Using values in an array in a subquery
Previous Message Tom Lane 2005-11-09 16:37:36 Re: Dump/restore needed from 8.1b1 to 8.1.0?