Mysql Date Filter
Mysql Date Filter is used to find the date portion of the timestamp for comparison specified in Where Clause.
Query for creating table employee1:-
The Query is used to create a table 'employee1'.The create table construct a table 'employee 1' with specific field name and data type respectively.
| CREATE TABLE employee1( Empid int(10),Empname varchar(60),date date ); |
Output:-
 |
Query for inserting data into the field:-
The insert into add the the records or rows value into the table 'employee1'.
| mysql> insert into employee1(Empid,Empname,date)values('01','Girish','2008-12-20'); Query OK, 1 row affected (0.02 sec) mysql> insert into employee1(Empid,Empname,date)values('02','Komal','2008-12-21'); Query OK, 1 row affected (0.02 sec) mysql> insert into employee1(Empid,Empname,date)values('03','vineet','2008-12-21'); Query OK, 1 row affected (0.03 sec) mysql> insert into employee1(Empid,Empname,date)values('04','Amit','2008-12-20'); Query OK, 1 row affected (0.02 sec) |
Query for viewing the records inserted into the table:-
The select is used to return the records from 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 | +-------+---------+------------+ 4 rows in set (0.00 sec) |
Query for filtering the record by date:-
The given below Query returns the records from table 'employee1' for the date portion comparison to current date specified in where clause.
| mysql> select * from employee1 where date=curdate(); |
Output:-
| +-------+---------+------------+ | Empid | Empname | date | +-------+---------+------------+ | 1 | Girish | 2008-12-20 | | 4 | Amit | 2008-12-20 | +-------+---------+------------+ 2 rows in set (0.00 sec) |