Date Calculations in MySQL

expiry = 20/03/2003

month(expiry) = 3

monthname(expiry) = March

dayofmonth(expiry) = 20

TO_DAYS(expiry) = Days from January 1st

(TO_DAYS(expiry) – TO_DAYS(current_date)) < 60

date_add(current_date, INTERVAL 90 DAYS)