Compare date in where clause
|
/* mysql> select * from Bird; +----------+-------+---------+------+------------+-------+ | name | owner | species | sex | birth | death | +----------+-------+---------+------+------------+-------+ | BlueBird | Joe | Car | f | 1999-03-30 | NULL | | RedBird | Yin | Car | m | 1979-03-30 | NULL | +----------+-------+---------+------+------------+-------+ 2 rows in set (0.00 sec)
mysql> /* which were born after 1998, test the birth column: */ mysql> SELECT * FROM Bird WHERE birth > '1998-1-1'; +----------+-------+---------+------+------------+-------+ | name | owner | species | sex | birth | death | +----------+-------+---------+------+------------+-------+ | BlueBird | Joe | Car | f | 1999-03-30 | NULL | +----------+-------+---------+------+------------+-------+ 1 row in set (0.00 sec)
*/ Drop table Bird;
CREATE TABLE Bird ( name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE ); INSERT INTO Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL); INSERT INTO Bird VALUES ('RedBird','Yin','Car','m','1979-03-30',NULL); select * from Bird;
/* which were born after 1998, test the birth column: */ SELECT * FROM Bird WHERE birth > '1998-1-1';
|
|
|
|
|
Related Scripts with Example Source Code in same category :
-
-
-
-
-
|
|