Displaying 1 result from an estimated 1 matches for "dlftest".
Did you mean:
dftest
2012 May 12
1
Query regarding date as argument in functions - and about sqldf
...uot;, "TMSTMP", "PRICE",
"DATE", "TTE", "DTTM", "SPOT", "MONEYNESS", "TTEBY7", "COMB",
"RATE"), row.names = c(NA, 6L), class = "data.frame")
Below are the commands and their outputs:
> dlftest = sqldf("select * from dlfhead where DATE = '2011-01-03'")
> nrow(dlftest)
[1] 0
Kindly note that in the above, the query does complete successfully with
'dlftest' created with 0 rows. When I run the select on a column with class
other than date I get the output.
>...