Fetching records between two date ranges
Between two years SELECT * FROM `dt_tb` WHERE year( dt2 ) between 2004 and 2005 Between two month ranges. SELECT * FROM `dt_tb` WHERE month(dt) between '02' and '08' SELECT * FROM `dt_tb` WHERE month(dt) between '02' and '08' and year(dt) between 2004 and 2005 Between two date ranges SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31'