| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
| Cc: | Jonathan Vallar <jonathan(dot)vallar(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Bad Value for Data Type Timestamp |
| Date: | 2006-02-28 17:04:36 |
| Message-ID: | Pine.BSO.4.63.0602281200490.2638@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Tue, 28 Feb 2006, Dave Cramer wrote:
> What you sent as sample data is formatted correctly. So the only thing I can
> think of is that the mapping of the columns is not correct.
Actually what he sent as sample data contained a space before the seconds
field, "2006-02-27 19:51: 22.58118". I don't know how this got into the
data because it gets rejected if you try and input it.
jurka=# select '2006-02-27 19:51: 22.58118'::timestamp;
ERROR: invalid input syntax for type timestamp: "2006-02-27 19:51:
22.58118"
Jonathan, are you sure the data coming back from psql has a space in it?
Any idea how you got into that state?
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2006-02-28 17:57:31 | Re: Bad Value for Data Type Timestamp |
| Previous Message | Dave Cramer | 2006-02-28 12:03:53 | Re: Bad Value for Data Type Timestamp |