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