Well done! Next, let's see what kind of operators we can use to compare timestamp data. This query ...
WHERE registration_timestamp >= '2010-01-01';
AND registration_timestamp < '2016-01-01'
... displays the ID of aircraft where the registration date is within the years 2010 – 2015. Briefly, these are the operators you can use with date and time data:
< – less than.
> – greater than.
<= – less than or equal to.
>= – greater than or equal to.
Remember that because of the high precision of timestamp data, it's a bad idea to use an equality operator (