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) |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
