Minus 1 Day and Year range

Wenggo · October 22nd, 2010, 08:20 PM

Hi all,

If there any best ways we had to code in Mysql :-

-- minus 1 YEAR range if today 2010-10-23
SELECT me FROM them
WHERE them.you > '2009-10-22' AND them.you < '2010-10-23'

-- minus 1 DAY range if today 2010-10-23
SELECT me FROM them
WHERE them.you > '2010-10-22' AND them.you < '2010-10-23'

Thanks.

Old Pedant · October 22nd, 2010, 08:28 PM

Code:

SELECT me FROM them 
WHERE you > CURDATE() 
AND you  < DATE_ADD( DATE_ADD( CURDATE(), INTERVAL 1 YEAR ), INTERVAL 1 DAY )

Wenggo · October 23rd, 2010, 11:46 PM

Thanks for your kindness Old Pedant,

I did it as yours where I want to have 1 Year range between 2009 till 2010 holding yesterday date:-

SELECT me FROM them
WHERE you > DATE_ADD( DATE_ADD( CURDATE(), INTERVAL -1 YEAR), INTERVAL -1 DAY) AND you < CURDATE()

regards..