Define and use Date data type : Date Type « Date Time « SQL / MySQL






Define and use Date data type

  
/*
mysql> Drop table Bird;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE Bird (
    ->     name VARCHAR(20),
    ->     owner VARCHAR(20),
    ->     species VARCHAR(20),
    ->     sex CHAR(1),
    ->     birth DATE,
    ->     death DATE
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO  Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL);
Query OK, 1 row affected (0.00 sec)

mysql> select * from Bird;
+----------+-------+---------+------+------------+-------+
| 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);

select * from Bird;

           
         
    
  








Related examples in the same category

1. Date and Time Sizes, Formats, and Ranges
2.Define and check the date data type
3.Show current date
4.Use date data type
5.Defining Set Membership:Finding Records in a Set
6.Performing Range Tests 3
7.Performing Range Tests 1
8.Performing Range Tests 2
9.Convert Date to int
10.The date/time data types
11.Date and Time Column Types
12.Date and Time Sizes, Formats, and Ranges