Displaying 1 result from an estimated 1 matches for "date_tm".
Did you mean:
date_tz
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
...=b.l5_product_hierarchy_code
and a.account_opening_date between start_dt and end_dt")
####################################################################
As it is not possible to reproduce error with the above code, I am providing
sample example as below with sqldf function using dataframe.
date_tm <- as.Date(c('2010-11-01', '2011-11-01','2010-12-01', '2011-01-01',
'2011-02-01'))
x1 <- c(1,2,3,4,5)
x2 <- c(100,200,300,400,500)
test_data <- data.frame(x1,x2,date_tm)
test_data
start_dt <- as.Date('2011-01-01',format="%Y-%m-%...