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






Performing Range Tests 2

  
/*
mysql> SELECT ExamID, SustainedOn, Comments FROM Exam
    -> WHERE SustainedOn BETWEEN '2003-03-20' AND '2005-03-11';
+--------+-------------+-----------------+
| ExamID | SustainedOn | Comments        |
+--------+-------------+-----------------+
|      2 | 2004-03-13  | C# test         |
|      3 | 2005-03-11  | JavaScript Test |
+--------+-------------+-----------------+
2 rows 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 BETWEEN '2003-03-20' AND '2005-03-11';

           
         
    
  








Related examples in the same category

1. Date and Time Sizes, Formats, and Ranges
2.Define and check the date data type
3.Define and use Date data type
4.Show current date
5.Use date data type
6.Defining Set Membership:Finding Records in a Set
7.Performing Range Tests 3
8.Performing Range Tests 1
9.Convert Date to int
10.The date/time data types
11.Date and Time Column Types
12.Date and Time Sizes, Formats, and Ranges