Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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


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;


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.