Format Date posted from a form

[freebie]

Hi,
I'm working with PHP, and I usually use MySQL to format dates before returning them from the database. In this case however, the date is passed to the PHP script via a form, and I want to be able to format it. Can someone recommend a solution. The date is posted to the processing page in the MySQL format. Is there a quick way to convert this to a unix timestamp?

Here's what I'm currently attempting which doesn't seem to work (I thought I'd use MySQL to do the formatting without specifying a table, as such). Is it possible to use MySQL like this (without specifying a table) ?

$DateFormatQuery="select DATE_FORMAT(".$_POST['DropOffDate'].",'%W %M %D, %Y')";

echo "Drop Off Date: " . mysql_result(mysql_query($DateFormatQuery,0)) . "<br>";

Thanks for any suggestions.
Jeff

[freebie]

I just found an easy solution actually.
Here it is in case it helps anyone.

list($Year,$Month,$Day) = split('-',$datevariable);
$stampeddate = mktime(12,0,0,$Month,$Day,$Year);
echo date("d M Y",$stampeddate);

Jeff