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
14. Comparing dates and times using operators
Date and time data types in PostgreSQL
Extracting dates and times
Timezone conversion
Format date and time
Current date and time data
Summary

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'