date_timeの差分をdate_diffで見るのはいいんだけど、
何ヶ月経ってるのかを計算するとき無造作に30で割るってやったらダメかな...
って思ってたけど
こいつがいたとは
PERIOD_DIFF(date_format(now(),"%Y%m"), date_format(contract_date,"%Y%m"))
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme