[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) (tt) ll 1

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 * from DF)