[R-sig-DB] RMySQL still treats timestamp as character?

Prof Brian Ripley r|p|ey @end|ng |rom @t@t@@ox@@c@uk
Wed Sep 3 09:09:00 CEST 2008


On Tue, 2 Sep 2008, David James wrote:

> Hi Alexy,
>
> Dates in MySQL (and other databases) may span outside the range of
> currently supported
> POSIX implementations (ie., under 32-bits), thus the character
> representation is known
> to work regardless of the dates themselves, e.g., before the Unix epoch.

Possibly, but R uses doubles for datetimes, unlike POSIX, and also has a 
classs for dates.  (Datetimes prior to 1850 are very dubious anyway, as 
there were no timezones.)  In other words, R's date and datetime classes 
are known to work as accurately as character representations.

>
> Regards,
>
> --
> David,
>
> On Sat, Aug 30, 2008 at 1:09 AM, Alexy Khrabrov <deliverable using gmail.com> wrote:
>> Greetings -- downloaded RMySQL 0.6.0, and on a table with timestamps it gets
>> them over as character.  Found an email in this group from 2006, about
>> switching to RODBC, did that, got lovely floats...  Any progress on that for
>> RMySQL proper?
>>
>> Cheers,
>> Alexy
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-sig-DB mailing list