CoderZone.org

Category: >> mySQL >> Add or Subtract days Bookmark and Share

<< lastnext >>

Snippet Name: Add or Subtract days

Description: Use INTERVAL to add or subtract days.

Comment: (none)

Author: CoderZone
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
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 8