Robert Fitzpatrick <robert@webtent.com> writes:
>>> My input file has the timestamp value like
>>> 2004-09-30 11:31:00.000
> What about the ".000" on the end? I am not able to enter that format in
> a timestamp field in 7.4.5, it is invalid.
Nonsense.
regression=# select '2004-09-30 11:31:00.000'::timestamp;
timestamp
---------------------
2004-09-30 11:31:00
(1 row)
regression=# select '2004-09-30 11:31:00.001'::timestamp;
timestamp
-------------------------
2004-09-30 11:31:00.001
(1 row)
regression=# select '2004-09-30 11:31:00.000'::timestamptz;
timestamptz
------------------------
2004-09-30 11:31:00-04
(1 row)
regards, tom lane