[R] stfrtime function not returning proper results through sqldf package in R

[Manohar Reddy]

Hi ,



  I have data something looks like below (or PFA), but when I’m extracting
month  using *strftime*  function through *sqldf* library ,it’s returning
below results but it’s not returning exact results ,it supposed to return
 05,05,05,06,06,06.Can anyone please guide me how to do that with *strftime*
function.



Thanks in advance.



Quiries :


library(scales)

# load data:
log <- data.frame(Date =
c("2013/05/25","2013/05/28","2013/05/31","2013/06/01","2013/06/02","2013/06/05","2013/06/07"),
  Quantity = c(9,1,15,4,5,17,18))


# convert date variable from factor to date format:
log$Date <- as.Date(log$Date,
  "%Y/%m/%d") # tabulate all the options here
str(log)







Manu.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: strftime_sqldf_screenshot.PNG
Type: image/png
Size: 28620 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20160916/099a3c19/attachment.png>