From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | Le-shin Wu <leshin(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: import data from openoffice Calc |
Date: | 2009-12-01 23:38:43 |
Message-ID: | 602571259.8519001259710723635.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- "Le-shin Wu" <leshin(at)gmail(dot)com> wrote:
> Hi Adrian,
>
> Thanks for your information. I think your suggestion will be my last
> approach, if I really can not find a way to solve my problem.
> Actually, I tried to format the cells type (the "date" column in my
> sheet) in Calc as "Date" before I copy and past, but somehow it works
> for only once. This also confused me. Thanks again.
>
> LW
>
Once the column is formatted as "Date" the underlying value will be the integer value. I did a little test and found the following. If I preformatted a column as "Text" and then entered date strings for example "12/01/09" it stayed a string when cut and pasted. If I just started entering a date string in a column the column would become a "Date" column. Changing the formatting to "Text" would change the date strings "12/01/09" to the underlying integer 40147. Any new date strings entered however would stay as "12/01/09". Hope this helps.
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Bret | 2009-12-01 23:39:29 | Re: optimizing advice |
Previous Message | Bret | 2009-12-01 23:25:35 | Re: Synchronize filenames in table with filesystem |