mySQL: Add or Subtract days - Use INTERVAL to add or subtract days.

Quick Search:

mySQL: Add or Subtract days

Jump to:

Snippet Name: Add or Subtract days

Description: Use INTERVAL to add or subtract days.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT * FROM date_table
WHERE xyz BETWEEN NOW() - INTERVAL 365*15 DAY 
AND NOW() - INTERVAL 365*15-7 DAY