How to get date from the datetime in php

$result = mysql_query("SELECT `datetime` FROM `table`");
$row = mysql_fetch_row($result);
$date = date_create($row[0]);

echo date_format($date, 'Y-m-d H:i:s');

echo date_format($date, 'd/m/Y H:i:s');

echo date_format($date, 'd/m/y');

echo date_format($date, 'g:i A');

echo date_format($date, 'G:ia');

echo date_format($date, 'g:ia \o\n l jS F Y');

How To Get Month Number to Month Name in PHP

<?php
$monthNum = 5;
$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
echo $monthName;
?>
//output: May

Select query to get total # records for each day in a month

select day(DateField), count(*) from table where month(DateField) = month(NOW()) and year(DateField) = year(NOW()) group by day(DateField)