Dealing with dates
Working with time
Date and time data types in PostgreSQL
Extracting dates and times
Intervals
Timezone conversion
Format date and time
Current date and time data
Instruction
Well done! You can use the following operators to compare time data:
<– less than.>– greater than.<=– less than or equal to.>=– greater than or equal to.
Look at this query:
SELECT code, arrival_time FROM route WHERE arrival_time >= '12:00:00' AND arrival_time <= '15:00:00';
It displays the codes and arrival times only for routes where the arrival time is at least 12:00:00 and not after 15:00:00.
Exercise
Show the code and departure time for all routes where the departure time is later than 14:00:00 but earlier than 23:00:00.
Stuck? Here's a hint!
Use the following expression:
WHERE departure_time < '23:00:00' AND departure_time > '14:00:00'
