title: How to use datediff mysql function in a mysql query on data frames in R using sqldf package
body: <p>I have 2 data frames. I have to use a mysql query on these 2 frames based on a condition which subtracts the date columns in the 2 frames. So, I am using sqldf package to use data frames in a mysql query, but it is not letting me use DATEDIFF function to subtract dates. Can anyone please let me know how can I solve this problem and use datediff since sqldf is not accepting this function.</p>