Convert date to month name & year

No Need of DATE_FORMAT() function.

Example-1: If 00 used in day. Then, output will be June, 2017

<?php
$date = '2017-07-00';
echo date('F, Y', strtotime($date)); //June, 2017
?>

Example-2: If 01 or valid day used in day. Then, output will be July, 2017

<?php
$date = '2017-07-01';
echo date('F, Y', strtotime($date)); //July, 2017
?>

You are not using correct parameters, use F for moth and Y for year

Full code:

$date = '2017-07-00';
$date = date('F, Y ', strtotime($date));
echo $date;

Tags:

Mysql

Php