Re: import data from openoffice Calc

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <aklaver(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Le-shin Wu" <leshin(at)gmail(dot)com>
Subject: Re: import data from openoffice Calc
Date: 2009-12-01 16:32:00
Message-ID: 2568.1259685120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <aklaver(at)comcast(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Le-shin Wu 2009-12-01 16:55:24 Re: import data from openoffice Calc
Previous Message Scott Marlowe 2009-12-01 16:26:36 Re: [GENERAL] [HACKERS] Fwd: psql+krb5