| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
| Cc: | Allen Landsidel <alandsidel(at)gmail(dot)com>, Goutam Paruchuri <gparuchuri(at)oneil(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Copy command and import - MS SQL Server to Postgres |
| Date: | 2004-11-06 03:57:56 |
| Message-ID: | 25455.1099713476@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Robert Fitzpatrick <robert(at)webtent(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2004-11-06 04:04:38 | Re: [GENERAL] Gborg down? |
| Previous Message | Marc G. Fournier | 2004-11-06 03:52:54 | Re: Gborg down? |