Re: [R] sqldf with date (class date) variables ?

sqldf has some facilities for Date class but has no knowledge of date class. See example 7b on home page: http://sqldf.googlecode.com and here is a second example: > DF <- data.frame(D = as.Date(c("21DEC2006","15DEC2006"), "%d%b%Y")) > DF D 1 2006-12-21 2 2006-12-15 > sqldf("select * f

[R] sqldf with date (class date) variables ?

Hello, I am having trouble with retrieving some data in queries involve with variables with data type "date". See the enclosed example: ll<-c("21DEC2006","15DEC2006") ss<-data.frame(ll) ss<-transform(ss,ll=as.date(as.character(ll))) (ss) ll 1 17156 2 17150 tt<-sqldf("select ll from ss") (t