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

Common Functions in PostgreSQL

Introduction
Dealing with dates
Working with time
Date and time data types in PostgreSQL
21. Sorting timestamp data
Extracting dates and times
Timezone conversion
Format date and time
Current date and time data
Summary

Instruction

Excellent! The last thing you should know about timestamp data is that you can sort with ORDER BY:

SELECT id, registration_timestamp
FROM aircraft
ORDER BY registration_timestamp;

Exercise

Show the id and launched_timestamp data for all aircraft launched in 2013 or 2014. Sort by launched_timestamp, going from the newest dates to the oldest.