SQL Get Current Date

Databases allow you to compare a column or result set against today's current date.

PostgreSQL, MySQL, Oracle

SQL Server

select
    *
from
    rent_payments
where 
    payment_date < current_date;

Assume that we run this query on March 5th, 2018 (3/5/2018).