Sorting by Calendar Day

     
mysql>
mysql> CREATE TABLE event
    -> (
    ->  date            DATE,
    ->  description     VARCHAR(255)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO event (date,description)
    ->  VALUES
    ->          ('1789-07-04','US Independence Day'),
    ->          ('1776-07-14','Bastille Day'),
    ->          ('1957-10-04','Sputnik launch date'),
    ->          ('1958-01-31','Explorer 1 launch date'),
    ->          ('1919-06-28','Signing of the Treaty of Versailles'),
    ->          ('1732-02-22','George Washington\'s birthday'),
    ->          ('1989-11-09','Opening of the Berlin Wall'),
    ->          ('1944-06-06','D-Day at Normandy Beaches'),
    ->          ('1215-06-15','Signing of the Magna Carta'),
    ->          ('1809-02-12','database Lincoln\'s birthday');
Query OK, 10 rows affected (0.00 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT * FROM event;
+------------+-------------------------------------+
| date       | description                         |
+------------+-------------------------------------+
| 1789-07-04 | US Independence Day                 |
| 1776-07-14 | Bastille Day                        |
| 1957-10-04 | Sputnik launch date                 |
| 1958-01-31 | Explorer 1 launch date              |
| 1919-06-28 | Signing of the Treaty of Versailles |
| 1732-02-22 | George Washington's birthday        |
| 1989-11-09 | Opening of the Berlin Wall          |
| 1944-06-06 | D-Day at Normandy Beaches           |
| 1215-06-15 | Signing of the Magna Carta          |
| 1809-02-12 | database Lincoln's birthday         |
+------------+-------------------------------------+
10 rows in set (0.00 sec)

mysql>
mysql>
mysql> SELECT date, description FROM event ORDER BY date;
+------------+-------------------------------------+
| date       | description                         |
+------------+-------------------------------------+
| 1215-06-15 | Signing of the Magna Carta          |
| 1732-02-22 | George Washington's birthday        |
| 1776-07-14 | Bastille Day                        |
| 1789-07-04 | US Independence Day                 |
| 1809-02-12 | database Lincoln's birthday         |
| 1919-06-28 | Signing of the Treaty of Versailles |
| 1944-06-06 | D-Day at Normandy Beaches           |
| 1957-10-04 | Sputnik launch date                 |
| 1958-01-31 | Explorer 1 launch date              |
| 1989-11-09 | Opening of the Berlin Wall          |
+------------+-------------------------------------+
10 rows in set (0.00 sec)

mysql> drop table event;
Query OK, 0 rows affected (0.00 sec)

Related examples in the same category

1.	Date type value in the form '2003-12-31', range 1000-01-01 to 9999-12-31 (3 bytes)
2.	To find the row with the most recent birth date, the query is similar, except that you sort in descending orde
3.	Compare with Date value
4.	How MySQL deals with incorrect date value
5.	Date literal in where clause
6.	Date value literal
7.	Date type value inside in operator and subquery
8.	Date calculation with variable
9.	Date default value

Sorting by Calendar Day : Date « Data Type « SQL / MySQL

Related examples in the same category