Deviopath › PostgreSQL

Overdue Loans

Medium · Dates

Subtracting one date from another gives the number of days between them as an integer: DATE '2026-03-15' - DATE '2026-03-10' is 5.

Today is 2026-03-15. A loan is overdue when it has not been returned (returned_on is NULL) and its due_on is before 2026-03-15 (a loan due today is not overdue yet). Return title, member (the member's name), due_on and days_overdue (2026-03-15 minus due_on). Sort by days_overdue descending, then title ascending.

Next: Products in Each Order