formating dates ??

[stuartc1]

Hi Folks,

I am looking to format dates that I have in an array to a more readable format.
This is how I am currently doing it, is there an easier way ?

$myqry="SELECT Date_Format('$Day[0]','%d/%m/%y')";
$Saturday=mysql_fetch_array(mysql_query($myqry,$db));

Cheers

[daynah]

How about this function?

function ConvertNiceDate($date)
{
// Convert mySQL date to nice formatted date
$normaldate = mysql_query("SELECT DATE_FORMAT('$date','%c/%e/%y')");
$normaldate = mysql_fetch_row($normaldate);
$normaldate = $normaldate[0];
return $normaldate;
}

For more conversion types, try looking at this page: http://www.mysql.com/doc/D/a/Date_and_time_functions.html

[Anon]

lose the opening quote:
<?
echo "<P> Order Processed at";
echo date("H:i, jS F");
echo "<br>";
?>