ขอสอบถามการคิวรี่ข้อมูลในช่วงระหว่าง เวลาเริ่มต้นกับสิ้นสุดหน่อยครับ

<?
$inputStart = "2012-06-02";
$inputEnd = "2012-06-05";

$sql = "SELECT * FROM absence 
WHERE (employee_id = '".$employee_id."') and
((endate  BETWEEN '".$inputStart."' and '".$inputEnd."') or (endate   BETWEEN '".$inputStart."' and '".$inputEnd."')) ";
?>

$sql = "SELECT * FROM absence WHERE employee_id = '".$employee_id."' and ( ('".$startDate."' BETWEEN stdate and endate) and ('".$endDate."'  BETWEEN stdate and endate) ) ";

$sql = "SELECT * FROM absence WHERE employee_id = '".$employee_id."' and (  ( ('".$startDate."' BETWEEN stdate and endate) or '".$startDate."' >= endate ) and ('".$endDate."'  BETWEEN stdate and endate) ) ";

<?
$inputStart = "2012-06-02";
$inputEnd = "2012-06-05";

$sql = "SELECT * FROM absence 
WHERE (employee_id = '".$employee_id."') and
((endate  BETWEEN '".$inputStart."' and '".$inputEnd."') or (endate   BETWEEN '".$inputStart."' and '".$inputEnd."')) ";
?>

<?
$inputStart = "2012-06-02";
$inputEnd = "2012-06-05";

$sql = "SELECT * FROM absence 
WHERE (employee_id = '".$employee_id."') and
((stdate BETWEEN '".$inputStart."' and '".$inputEnd."') or (endate   BETWEEN '".$inputStart."' and '".$inputEnd."')) ";
?>

SELECT * FROM absence WHERE (employee_id = '999001') and ((stdate BETWEEN '2012-06-12' and '2012-06-13') or (endate BETWEEN '2012-06-12' and '2012-06-13'))

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 10, 2012 at 04:51 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `eleave_cit`
--

-- --------------------------------------------------------

--
-- Table structure for table `absence`
--

CREATE TABLE IF NOT EXISTS `absence` (
  `a_id` int(10) NOT NULL AUTO_INCREMENT,
  `absence_no` varchar(10) NOT NULL,
  `employee_id` varchar(10) NOT NULL,
  `document_subject` varchar(500) NOT NULL,
  `type_no` char(15) NOT NULL,
  `stdate` date NOT NULL,
  `endate` date NOT NULL,
  `status` char(1) NOT NULL,
  `dayno` float NOT NULL,
  `entrancedate` datetime NOT NULL,
  `approvedate` datetime NOT NULL,
  PRIMARY KEY (`a_id`),
  UNIQUE KEY `absence_no` (`absence_no`),
  KEY `absence_no_2` (`absence_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=261 ;

--
-- Dumping data for table `absence`
--

INSERT INTO `absence` (`a_id`, `absence_no`, `employee_id`, `document_subject`, `type_no`, `stdate`, `endate`, `status`, `dayno`, `entrancedate`, `approvedate`) VALUES
(259, '55SCK303', '999001', 'test', 'SCK', '2012-04-02', '2012-04-03', 'A', 2, '2012-06-10 08:57:20', '2012-06-10 08:57:26'),
(255, '55SCK299', '999001', 'test', 'SCK', '2012-08-06', '2012-08-09', 'A', 4, '2012-06-08 10:01:23', '2012-06-08 10:01:29'),
(253, '55SCK297', '999001', 'test', 'SCK', '2012-06-05', '2012-06-06', 'A', 2, '2012-06-08 09:19:44', '2012-06-08 09:20:00'),
(252, '55PSN296', '999001', 'test', 'PSN', '2012-06-11', '2012-07-11', 'A', 23, '2012-06-08 09:17:39', '2012-06-08 09:17:46'),
(260, '55SCK304', '353734', 'test', 'SCK', '2012-04-09', '2012-04-10', 'A', 2, '2012-06-10 08:58:51', '2012-06-10 09:07:34');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

<?
$inputStart = "2012-06-02";
$inputEnd = "2012-06-05";

$sql = "SELECT * FROM absence 
WHERE (employee_id = '".$employee_id."') and
(('".$inputStart."'  BETWEEN stdate and endate) or ('".$inputEnd."' BETWEEN stdate and endate)) ";
?>