รบกวนสอบถามค้นหาตามช่วงเวลา ที format เป็น Datetime ครับ

SELECT * FROM `tb_time` 
WHERE ( start  BETWEEN '2015-08-05 12:00' and '2015-08-08 12:00') 
OR ( end BETWEEN '2015-08-05 12:00' and '2015-08-08 12:00')

SELECT * FROM `tb_time` 
WHERE ( `start` BETWEEN '2015-08-05 12:00' and '2015-08-08 12:00') 
OR ( `end` BETWEEN '2015-08-05 12:00' and '2015-08-08 12:00')

WHERE ((car_r_start_date BETWEEN '$d_start' and '$d_end') OR (car_r_end_date BETWEEN '$d_start' and '$d_end')

WHERE (car_r_start_date BETWEEN CAST('$d_start' AS DATETIME) AND CAST('$d_end' AS DATETIME)) OR (car_r_end_date BETWEEN CAST('$d_start' AS DATETIME) AND CAST('$d_end' AS DATETIME))

$query_Re_car_r .= "WHERE (car_r_start_date <= CAST($d_start AS DATETIME)) AND car_r_end_date >= CAST($d_start AS DATETIME)) OR (car_r_end_date >= CAST($d_end AS DATETIME)) AND car_r_start_date <= CAST($d_end AS DATETIME))

WHERE ((car_r_start_date BETWEEN '$d_start' and '$d_end') OR (car_r_end_date BETWEEN '$d_start' and '$d_end')

SELECT * FROM `118303` WHERE UNIX_TIMESTAMP('2015-09-02 12:00:00') BETWEEN UNIX_TIMESTAMP(sd) AND UNIX_TIMESTAMP(ed)
OR UNIX_TIMESTAMP('2015-09-04 16:00:00') BETWEEN UNIX_TIMESTAMP(sd) AND UNIX_TIMESTAMP(ed)

CREATE TABLE IF NOT EXISTS `118303` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sd` datetime DEFAULT NULL,
  `ed` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DELETE FROM `118303`;
/*!40000 ALTER TABLE `118303` DISABLE KEYS */;
INSERT INTO `118303` (`id`, `data`, `sd`, `ed`) VALUES
	(1, 'กข-1001', '2015-09-01 12:00:00', '2015-09-05 12:00:00'),
	(2, 'กข-1001', '2015-09-10 12:00:00', '2015-09-15 12:00:00'),
	(3, 'กข-1234', '2015-09-01 12:00:00', '2015-09-04 12:00:00'),
	(4, 'กข-1234', '2015-09-04 15:00:00', '2015-09-08 12:00:00');

SET @SD = '2015-09-03 12:00:00';
SET @ED = '2015-09-10 16:00:00';
SELECT * FROM `118303` WHERE UNIX_TIMESTAMP(@SD) BETWEEN UNIX_TIMESTAMP(sd) AND UNIX_TIMESTAMP(ed)
OR UNIX_TIMESTAMP(@ED) BETWEEN UNIX_TIMESTAMP(sd) AND UNIX_TIMESTAMP(ed)
OR UNIX_TIMESTAMP(sd) BETWEEN UNIX_TIMESTAMP(@SD) AND UNIX_TIMESTAMP(@ED) 
OR UNIX_TIMESTAMP(ed) BETWEEN UNIX_TIMESTAMP(@SD) AND UNIX_TIMESTAMP(@ED) 

WHERE 
 (
 UNIX_TIMESTAMP('$d_start') >= UNIX_TIMESTAMP(car_r_start_date)
 AND 
 UNIX_TIMESTAMP('$d_start') <= UNIX_TIMESTAMP(car_r_end_date)
 ) 
 
 OR 
 
 (
 UNIX_TIMESTAMP('$d_end') >= UNIX_TIMESTAMP(car_r_start_date) 
 AND 
 UNIX_TIMESTAMP('$d_end') <= UNIX_TIMESTAMP(car_r_end_date)
 ) 
 
 OR
 
 (
 UNIX_TIMESTAMP('$d_start') <= UNIX_TIMESTAMP(car_r_start_date) 
 AND 
 UNIX_TIMESTAMP('$d_end') => UNIX_TIMESTAMP(car_r_end_date)
 )

 WHERE(((UNIX_TIMESTAMP('2015-09-09 12:00') >= UNIX_TIMESTAMP(car_r_start_date)) AND (UNIX_TIMESTAMP('2015-09-09 12:00') <= UNIX_TIMESTAMP(car_r_end_date))) OR ((UNIX_TIMESTAMP('2015-09-16 13:00') >= UNIX_TIMESTAMP(car_r_start_date)) AND (UNIX_TIMESTAMP('2015-09-16 13:00') <= UNIX_TIMESTAMP(car_r_end_date))) OR ((UNIX_TIMESTAMP('2015-09-09 12:00') <= UNIX_TIMESTAMP(car_r_start_date)) AND (UNIX_TIMESTAMP('2015-09-09 12:00') <= UNIX_TIMESTAMP(car_r_end_date)) AND (UNIX_TIMESTAMP('2015-09-16 13:00') >= UNIX_TIMESTAMP(car_r_start_date)) AND (UNIX_TIMESTAMP('2015-09-16 13:00') >= UNIX_TIMESTAMP(car_r_end_date))))