AGE function for differences in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the AGE function in PostgreSQL do?

The AGE function calculates the difference between two dates or timestamps and returns the result as an interval showing years, months, and days.

beginner

How do you use AGE to find the difference between the current date and a past date?

Use AGE(current_date, past_date). For example, AGE(current_date, '2000-01-01') returns the time passed since January 1, 2000.

beginner

What is the output type of the AGE function in PostgreSQL?

The output is an interval type that shows the difference in years, months, days, and time components.

intermediate

What happens if you use AGE with only one argument?

AGE with one argument returns the difference between the current date/time and the given timestamp.

intermediate

Why is AGE preferred over simple subtraction for date differences?

AGE accounts for months and years properly, giving a human-readable difference, while subtraction returns just the number of days.

What does AGE('2024-06-01', '2023-06-01') return?

A 365 days

B 1 year

C 12 months

D 30 days

AGE returns the difference as an interval showing 1 year between the two dates.

Which data type does AGE return in PostgreSQL?

A Date

B Integer

C Interval

D Timestamp

AGE returns an interval type representing the difference between dates.

What is the result of AGE('2024-06-01') if today is '2024-06-10'?

A 9 days

B 10 days

C 1 day

D 0 days

AGE with one argument returns the difference from the current date/time to the given date, which is 9 days.

If you subtract two dates directly (date1 - date2), what do you get?

A Number of days as an integer

B Timestamp

C Interval with years and months

D String describing difference

Direct subtraction returns the number of days as an integer, not a detailed interval.

Why might AGE('2024-06-01', '2023-12-01') return '6 mons' instead of '182 days'?

A AGE rounds to nearest day

B AGE returns seconds

C AGE only works with years

D AGE counts months and years, not just days

AGE returns a human-readable interval counting months and years, not just total days.

Explain how the AGE function calculates the difference between two dates in PostgreSQL.

Think about how AGE shows time passed in years and months, not just days.

Describe the difference between using AGE and simple date subtraction for finding date differences.

Consider what each method returns and how it represents the difference.