Working with INTERVAL and CURDATE in MySQL

by

You need DATE_ADD/DATE_SUB:

AND v.date > (DATE_SUB(CURDATE(), INTERVAL 2 MONTH))
AND v.date < (DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

should work.

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. How to select date from datetime column?
  5. mysql: get record count between two date-time
  6. How to cast DATETIME as a DATE in mysql?
  7. MySQL – select data from database between two dates
  8. How to compare timestamp dates with date-only parameter in MySQL?
  9. How to convert a string to date in MySQL?
  10. Converting a date in MySQL from string field
  11. MySQL: Select All Dates In a Range Even If No Records Present
  12. Mysql: Select all data between two dates
  13. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  14. MySQL Query – Records between Today and Last 30 Days
  15. MySQL Query to select data from last week?
  16. MySQL convert date string to Unix timestamp
  17. CURRENT_DATE/CURDATE() not working as default DATE value
  18. How to get difference between two dates in months using MySQL query?
  19. Select mysql query between date?
  20. SQL Query to show nearest date?
  21. How to subtract hours from a datetime in MySQL?
  22. Select data between a date/time range
  23. Date in a URL dd/mm/yyyy
  24. Select all months within given date span, including the ones with 0 values
  25. Update date + one year in mysql
  26. mysql date comparison with date_format
  27. how to partition a table by datetime column?
  28. MySQL cumulative sum grouped by date
  29. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  30. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?

Leave a Comment