PostgreSQL – AGE Function
In PostgreSQL the age() function is used to calculate ages.
Syntax: age(timestamp, timestamp);
Let’s analyze the above syntax:
- The age() function accepts two TIMESTAMP values
- It subtracts the second argument from the first one and returns an interval as a result.
Example 1:
Here we will evaluate the age of a person whose birth date is 2000-01-01 and the current date 2020-03-20, through the below statement:
SELECT current_date, AGE(timestamp '2000-01-01');
Output:
Example 2:
The below statement query to get the top 10 rentals that have the longest durations, from the rental table of the sample database:
SELECT rental_id, customer_id, age(return_date, rental_date) AS duration FROM rental WHERE return_date IS NOT NULL ORDER BY duration DESC LIMIT 10;
Output:
Contact Us