Performing Range Tests 1 : Date Type « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. Date Type

Performing Range Tests 1

  
/*
mysql> SELECT ExamID, SustainedOn, Comments FROM Exam
    -> WHERE SustainedOn >= '2003-03-20'
    -> AND SustainedOn <= '2004-12-31';
+--------+-------------+----------+
| ExamID | SustainedOn | Comments |
+--------+-------------+----------+
|      2 | 2004-03-13  | C# test  |
+--------+-------------+----------+
1 row in set (0.01 sec)


*/

/* Prepare the data */ 
DROP TABLE Exam;

CREATE TABLE Exam (
   ExamID      INT NOT NULL PRIMARY KEY,
   SustainedOn DATE,
   Comments    VARCHAR(255)

)TYPE = InnoDB;


/* Insert data for testing */ 
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (1,'2003-03-12','Java Test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (2,'2004-03-13','C# test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (3,'2005-03-11','JavaScript Test');
  
/* Real command */
  
SELECT ExamID, SustainedOn, Comments FROM Exam
WHERE SustainedOn >= '2003-03-20'
AND SustainedOn <= '2004-12-31';

           
         
    
  

Related examples in the same category