Home Sql Sqldate Mysql Date Comparison

Mysql Date Comparison
Posted on: December 31, 2008 at 12:00 AM

Mysql Date Comparison is used to return the date from a table on the basis of comparison between any two values of dates.

Mysql Date Comparison

Mysql Date Comparison is used to return the date from a table on the basis of comparison between any two values of dates.

Understand with Example

The Tutorial illustrate an example from 'Mysql Date Comparison'. To understand this example we create a table 'Employee1' in the database.

Step1:-Create table name EMPLOYEE1 in the database:-

Query:-

CREATE TABLE EMPLOYEE1 (
ID int(2) NOT NULL auto_increment,
EMPNAME varchar(30),
ATTENDENCE varchar(10),
DAT date NOT NULL default '0000-00-00',
PRIMARY KEY (ID)
) ;

Output:-

Step2:-Insert the values in the table by giving the query given below:-

Query:-

INSERT into EMPLOYEE1 VALUES ('01','Girish','P','2008-12-01'),
('02','Komal','A','2008-12-02'),
('03','Mahendra','P','2008-12-03'),
('04','Sandeep','A','2008-12-04'),
('05','Amit','P','2008-12-05');

Output:-

Step3:-Write the query given below for comparing the given two dates:-

Query:-

The Query below return you the set of records from 'Employee1' whose value of date is greater than equal to '2008-12-01' and less than equal to '2008-12-03'.

SELECT * FROM EMPLOYEE1
WHERE DAT >='2008-12-01' AND DAT <='2008-12-03';

Output:-

Related Tags for Mysql Date Comparison:
sql, mysql, c, com, table, date, comparison, dates, sed, value, return, tab, values, to, between, e, iso, use, from, as, m, par, tween, es, s, urn, so, ee, etw, at, any, my, is, ar, va, tw, s, s, ri, th, ab, abl, asis, alu, pari, on, om, o

«Previous Index Next»