Mysql Get Month Difference Between 2 Dates

November 5, 2023
-

SELECT PERIOD_DIFF(DATE_FORMAT(i.expiry_date, '%Y%m'), DATE_FORMAT(CURRENT_TIMESTAMP, '%Y%m')) AS ExpireIn,

  SELECT PERIOD_DIFF(DATE_FORMAT(i.expiry_date, '%Y%m'), DATE_FORMAT(CURRENT_TIMESTAMP, '%Y%m')) AS RemainingMonths,

General