how to find month from date in sql php code example

Example 1: php grab month from date

$month = date("m",strtotime($mydate));

Example 2: how to get match date and month in php

date('m',strtotime('2018-06-30' )) == date('m');