Re: import data from openoffice Calc - Mailing list pgsql-general

From Adrian Klaver
Subject Re: import data from openoffice Calc
Date
Msg-id 1171988115.8513981259709915393.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net
Whole thread Raw
In response to Re: import data from openoffice Calc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
----- "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> Adrian Klaver <aklaver@comcast.net> writes:
> >> The problem is that dates in spreadsheets are stored as days from
> some
> >> date. For a more complete answer see:
> >> http://www.lexicon.net/sjmachin/xlrd.html
>
> Somebody should file a bug/RFE against OpenOffice, suggesting that
> there
> ought to be an option to store dates as dates when storing into SQL
> databases.
>
>             regards, tom lane


Someone beat me to it:
http://www.mail-archive.com/debian-openoffice@lists.debian.org/msg22449.html



Adrian Klaver
aklaver@comcast.net








pgsql-general by date:

Previous
From: raf
Date:
Subject: Re: how to install just client libraries on windows?
Next
From: "Bret"
Date:
Subject: Re: Synchronize filenames in table with filesystem