Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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

Instruction

Very well done! 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 the proper date format and use apostrophes: 'YYYY-MM-DD'. Use BETWEEN.