Add or Subtract days

Submitted by:Pitter Alderson

Date added:30 August, 2016

Category:MySQL

Use INTERVAL to add or subtract days.

Tags: subtract

Code Snippet:

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

Comments