Mysql Date in between

The Tutorial illustrates an example Mysql date in between . In this Tutorial we illustrate an example that help you to get the date in between.

Query for creating table:-

The create table statement create a table employees1 with field name and data type respectively.

Output:-

Query for inserting data:-

The insert into add the records or rows value into the table 'employee1'.

Query for Viewing data:-

The select return and display  the records from the table'employee1'.

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     1 | Girish  | 2008-12-20 |
|     2 | Komal   | 2008-12-21 |
|     3 | vineet  | 2008-12-21 |
|     4 | Amit    | 2008-12-20 |
|     2 | Komal   | 2008-12-23 |
|     2 | Sandeep | 2008-12-24 |
|     2 | suman   | 2008-12-25 |
+-------+---------+------------+
7 rows in set (0.00 sec)

Query for extracting record using date-in- between:-

The given below Query return you the Empid,Empname from table employee 1 where the value of date lies between  '2008-12-23'and '2008-12-25'.

Output:-

+-------+---------+
| Empid | Empname |
+-------+---------+
|     2 | Komal   |
|     2 | Sandeep |
|     2 | suman   |
+-------+---------+
3 rows in set (0.03 sec)