Skip to content

RMySQL still treats timestamp as character?

2 messages · David James, Brian Ripley

Original
David James
# 
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.

Regards,

--
David,
On Sat, Aug 30, 2008 at 1:09 AM, Alexy Khrabrov <deliverable at gmail.com> wrote:
Brian Ripley
#
On Tue, 2 Sep 2008, David James wrote:

            

      
      
      
    

        
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.