CODE EXAMPLE FOR C

mysql yyyymm format

select billing_month, DATE_FORMAT(now(), "%Y%m") as current_month, period_diff(DATE_FORMAT(now(), "%Y%m"), billing_month) as months from test