Mysql Date in between

Ads
 

Mysql Date in between

The Tutorial illustrates an example Mysql date in between . In this

The Tutorial illustrates an example Mysql date in between . In this

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.

mysql> CREATE TABLE employee1(
-> Empid int(10),
-> Empname varchar(60),
-> date date );

Output:-

Query for inserting data:-

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

mysql> insert into employee1 values('2','Komal','2008-12-23');
Query OK, 1 row affected (0.03 sec)

mysql> insert into employee1 values('2','Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)

mysql> insert into employee1 values('2','suman','2008-12-25');
Query OK, 1 row affected (0.03 sec)

Query for Viewing data:-

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

mysql> select * from 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'.

mysql> select Empid,Empname from employee1 where date between '2008-12-23'and '2008-12-25';

Output:-

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

 

Ads

Tutorials   

Ads