Displaying 2 results from an estimated 2 matches for "thedatefield".
2008 Dec 22
2
Treatment of Date ODBC objects in R (RODBC)
Dear all,
Retrieving an Oracle "Date" data type by means of RODBC (version
1.2-4) I get different classes in R depending on which operating
system I am in:
On MacOSX I get "Date" class
On Windows I get " "POSIXt" "POSIXct" class
The problem is material, as converting the "POSIXt" "POSIXct" object
with as.Date() returns one
2008 Dec 29
0
Serial Correlation Test for Short Time Series
...p at r-project.org
Message-ID:
<1947895168-1229964736-cardhu_decombobulator_blackberry.rim.net-2090033294-
@bxe348.bisx.prod.on.blackberry>
Content-Type: text/plain
I tend to avoid the issue by asking Oracle for a character string
representation of the date. I use sql like this:
to_char( thedatefield, 'yyyymmdd' ) as thedate
Then in R:
d <- as.Date( as.character( thedate, '%Y%m%d') )
Hope this helps,
Avram
------Original Message------
From: Ivan Alves
Sender: r-help-bounces at r-project.org
To: r-help at r-project.org
Sent: Dec 22, 2008 8:40 AM
Subject: [R] Treatment o...