Displaying 1 result from an estimated 1 matches for "mylovelydb".
2009 Jul 15
0
POSIX, timezones and R-ODBC
...t* the TZ variable to be set, which I did:
> Sys.getenv("TZ")
TZ
""
> Sys.setenv(TZ="America/New_York")
> Sys.getenv("TZ")
TZ
"America/New_York"
Next up:
library(RODBC)
library(quantmod)
channel <- odbcConnect("mylovelydb")
> GS = sqlQuery(channel, paste("select Date, o, h, l, c, v from GS ORDER BY
Date ASC"))
Error in as.POSIXlt.character(x, tz, ...) :
character string is not in a standard unambiguous format
In addition: Warning messages:
1: In structure(.Internal(as.POSIXct(x, tz)), class = c(...