Re: Copy command and import - MS SQL Server to Postgres - Mailing list pgsql-general

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