Interval data types
INTERVAL data types provide you with a very useful tool for performing arithmetic on date and time data types. For example, let's say our rental policy requires a DVD to be returned within 3 days. We can calculate the expected_return_date for a given DVD rental by adding an INTERVAL of 3 days to the rental_date from the rental table. We can then compare this result to the actual return_date to determine if the DVD was returned late.
Let's try this example in the exercise.
Bu egzersiz
Functions for Manipulating Data in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Select the rental date and return date from the
rentaltable. - Add an
INTERVALof 3 days to therental_dateto calculate the expected return date`.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
-- Select the rental and return dates
___,
___,
-- Calculate the expected_return_date
rental_date + ___ ___ AS expected_return_date
FROM rental;