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 NA
2 NA
> str(ss)
'data.frame': 2 obs. of 1 variable:
$ ll:Class 'date' int [1:2] 17156 17150
> str(tt)
'data.frame': 2 obs. of 1 variable:
$ ll:Class 'date' int [1:2] NA NA
So all the elements of ll (of tt) has been converted into NA. Is there anyway
that I can query the variables with "date" data type using sqldf?
Many Thanks,
Si.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
