"Patrick Hatcher" <PHatcher@macys.com> writes:
> I'm receiving a flat file dump from a DB2 feed. In this file, I have a
> number of timestamp fields that appear as such:
> 2002-10-30-19.00.05.224939. Pg doesn't seem to recognize this as a valid
> timestamp. I've tried converting the timestamp to 2002-10-30-19
> 00:05:224939 and 2002-10-30-19 00:05:22, but it still won't import.
I would think you want '2002-10-30 19:00:05.224939'.
regards, tom lane