month() function in a mysql date and time field

MONTH(date)

SELECT MONTH(  '2016-05-05' )

MONTHNAME(): Month Name in Full ( September )

SELECT date_format(date,'%b') as dt FROM table_name

SELECT month(dt2) FROM `dt_tb'

Difference in months

MySQLi database connection string

<?Php  require "config.php";// Database connection    $query="SELECT dt,dt2,month(dt) as month1,month(dt2)as month2,  (month( dt2 ) - month( dt )) as difference FROM `dt_tb` ";    if($stmt = $connection->query("$query")){      echo "No of records : ".$stmt->num_rows."<br>";      echo "<table class='table table-striped'>  <tr class='info'> <th> dt</th><th> dt2</th><th>month(dt)</th><th>month1</th><th>month2</th><th>Difference</th></tr>";  while ($row = $stmt->fetch_assoc()) {   echo "<tr><td>$row[dt]</td><td>$row[dt2]</td><td>$row[month1]</td><td>$row[month2] </td><td>$row[difference] </td></tr>";   }  echo "</table>";  }else{  echo $connection->error;  }  ///////////////////////  ?>

CREATE TABLE IF NOT EXISTS `dt_tb` (    `id` int(2) NOT NULL AUTO_INCREMENT,    `dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',    `dt2` date NOT NULL DEFAULT '0000-00-00',    PRIMARY KEY (`id`)  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;    --  -- Dumping data for table `dt_tb`  --    INSERT INTO `dt_tb` (`id`, `dt`, `dt2`) VALUES  (1, '2004-10-26 00:00:00', '2005-01-25'),  (2, '2004-05-05 23:56:25', '2005-06-12'),  (3, '2005-12-08 13:20:10', '2005-06-06');