import data from openoffice Calc

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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