Revision: 50174
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 13, 2011 13:07 by jafar
Initial Code
'SELECT * FROM events WHERE date > DATE_SUB(NOW(), INTERVAL 3 MONTH) AND date < DATE_ADD(NOW(), INTERVAL 3 MONTH) ORDER BY date DESC'
Initial URL
Initial Description
Select rows that are 3 months ahead or 3 months behind from the current date.
Initial Title
SQL SELECT 3 MONTHS +/-
Initial Tags
sql, date
Initial Language
SQL