Message-ID: <AANLkTimUW3FwyAWr6KcEH7h1mg3_xQbLHLhrQ7pZdtXD@mail.gmail.com>
Date: 2011-03-07T12:32:42Z
From: Xiaobo Gu
Subject: dbWriteTable in RPostgreSQL can't handle date and timestamp data types.
In-Reply-To: <C2281AC1-2DAB-4A6C-84C4-72C9DDB1B493@kenroku.kanazawa-u.ac.jp>
Can we specify data types for columns of the table created by
dbWriteTable, most times we want timestamp without timezone.
Another case is numeric numbers, in current implement all numeric data
are converted as float, but for some applications want it to be
decimal with scales,
Xiaobo Gu
On Mon, Mar 7, 2011 at 6:37 PM, Tomoaki NISHIYAMA
<tomoakin at kenroku.kanazawa-u.ac.jp> wrote:
> Hi,
>
>>> class(df[["c"]])
>>
>> [1] "Date"
>>>
>>> class(df[["d"]])
>>
>> [1] "POSIXct" "POSIXt"
>
>
> Ok, if you know the class name, the change is simple as r179.
> (r178, r180 are cleanups of other part)
> --
> Tomoaki NISHIYAMA
>
> Advanced Science Research Center,
> Kanazawa University,
> 13-1 Takara-machi,
> Kanazawa, 920-0934, Japan
>
>