[R] Fetching data from MySQL via odbcConnect - Error in as.POSIXlt.character(x, tz, ...) :
d-zimmermann at gmx.net
Mon Nov 25 16:19:09 CET 2013
I am trying to retrieve data from a MySQL Database using RODBC with the
commands odbcConnect and sqlFetch. There are different data files in the
database and in some cases it works without any difficulties. Nevertheless I
get an error with some data files. Since I'm not familiar with MySQL I hope
to get some ideas here.
My code looks as follows:
myconn <-odbcConnect("database", uid="user", pwd="password")
data1<- sqlFetch(myconn, 'data1')
data2 <- sqlFetch(myconn, 'data2')
It works fine for data1 but for data2 I get the following error:
Error in as.POSIXlt.character(x, tz, ...) :
character string is not in a standard unambiguous format
As I've checked the data files, they use the same types of variables and I
have no clue where the not standard unambiguous format stems from.
Hope to get some help!
View this message in context: http://r.789695.n4.nabble.com/Fetching-data-from-MySQL-via-odbcConnect-Error-in-as-POSIXlt-character-x-tz-tp4681116.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help