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

SELECT FROM table_name WHERE dte_field 
	BETWEEN '2015-03-01' AND LAST_DAY('2016-02-01')

Between two date ranges

SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31' 

Date Format to use in query

$date = new DateTime($dt2);
$dt2=$date->format('Y-m-d');

SELECT * FROM `dt_tb` WHERE dt BETWEEN BETWEEN '$dt1' AND '$dt2' 

CREATE TABLE dt_tb (
  id int(2) NOT NULL auto_increment,
  dt datetime NOT NULL default '0000-00-00 00:00:00',
  dt2 date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) ;

# Dumping data for table `dt_tb`

INSERT INTO dt_tb VALUES (1, '2004-10-26 00:00:00', '2005-01-25');
INSERT INTO dt_tb VALUES (2, '2004-05-05 23:56:25', '2005-06-12');
INSERT INTO dt_tb VALUES (3, '2005-12-08 13:20:10', '2005-06-06');
INSERT INTO dt_tb VALUES (4, '2003-05-26 00:00:00', '2007-12-18');
INSERT INTO dt_tb VALUES (5, '2007-12-18 00:00:00', '2003-08-16');