SQL SELECT 3 MONTHS +/- - SQL Snipplr Social Repository

Revision: 50174

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