你即將離開本站

並前往https://stackoverflow.com/questions/2793619/working-with-interval-and-curdate-in-mysql

Working with INTERVAL and CURDATE in MySQL

You need DATE_ADD/DATE_SUB : AND v.date > (DATE_SUB(CURDATE(), INTERVAL 2 MONTH)) AND v.date < (DATE_SUB(CURDATE(), INTERVAL 1 MONTH)).

確定！ 回上一頁

查詢 「MySQL INTERVAL」的人也找了：

  1. Mysql interval 1 day
    2.
  2. PostgreSQL interval
    3.
  3. MySQL DATE_ADD
    4.
  4. MySQL DATETIME format
    5.
  5. MySQL DATE_FORMAT
    6.
  6. MySQL CONVERT_TZ
    7.
  7. MySQL date INTERVAL
    8.
  8. MySQL TIMESTAMPDIFF
    9.