Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: import data from openoffice Calc
Date
Msg-id 2568.1259685120@sss.pgh.pa.us
Whole thread Raw
In response to Re: import data from openoffice Calc  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: import data from openoffice Calc  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Unexpected EOF on client connection
Next
From: Le-shin Wu
Date:
Subject: Re: import data from openoffice Calc