Correct Date Syntax?

[webgod]

Hi, is this syntax correct? I have a mysql DATE column called date_available that I'm attempting to make this happen:
July 10, 2004

Or is there a better way around this?

$part=explode("-",$row->date_available);
$newdate=date("F j, Y", mktime(0,0,0,$part[1],$part[2],$part[0]));

[altexis]

I would use:

$dt=strtotime($row->date_available);
$newdate=date("F j, Y", $dt);

[xblue]

I'd recommend to do the formatting right within your select query.

search for date_format on this page, it lists all formatting options:
http://www.mysql.com/doc/en/Date_and_time_functions.html