Introduction
Dates
Time
Timestamps
20. Timestamps with ORDER BY
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

Instruction

Very well. The last thing you should know about timestamps is that you can also sort them with ORDER BY:

SELECT id, launched
FROM aircraft
ORDER BY launched;

Of course, you can use DESC or ASC after ORDER BY.

Exercise

For all the aircraft launched in 2013 or 2014, show their id and launch date. Sort by the column launched from the newest to the oldest dates.

Stuck? Here's a hint!

Remember about the proper date format and use apostrophes: 'YYYY-MM-DD'. Use BETWEEN.

Console

Code editor

Result

TableConsole