| From: | Le-shin Wu <leshin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | import data from openoffice Calc |
| Date: | 2009-12-01 15:21:45 |
| Message-ID: | d44f0d640912010721p4d990e29pc0cf8fa9439e0d83@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I use OpenOffice Base as the front end tool to connect a postgreSQL server.
It works great. But when I am trying to create a table by copying data from
OpenOffice Calc and then pasting to my postgreSQL database (connected
through OpenOffice base), I always got an invalid input syntax error for
type "date". My original data showing in Clac is "12/17/99", but when
OpenOffice base tries to insert this data into a table, it became "36509".
The actual error is as below, can anyone help me to fix this problem. Thanks
a lot.
pq_driver:[PGRES_FATAL_ERROR]ERROR: invalid input syntx for type date:
"36509"
(caused by statement 'INSERT INTO "public"."DF" ("STK_NO","Date","Comments")
VALUES ('11','36509','small inversion'))
LW
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-12-01 15:22:03 | Re: [HACKERS] Fwd: psql+krb5 |
| Previous Message | Tom Lane | 2009-12-01 15:14:18 | Re: unexpected pageaddr |