sql date greater than year code example Example: date less than in sql SELECT * FROM wp_osd_properties WHERE `listing_expiration` < '2020-08-05'