MySQL DATE to PHP to display "readable" date

[Witzbold]

I have to admit I have come a far way in PHP and MySQL, but with this problem I have stepped outside my understanding.

 

I have a field in my SQL database that stores the original date that an mp3 was recorded and is stored in the date type in MySQL (YYYY-MM-DD) and so far I have just been displaying the date this way on the page, because I havn't been able to figure out a solution.  I want the information stored in database to display in MMM-DD-YYY format (MAR 20 2008) is there anyway to do this in code, without having to completely redo the code?

[rhodesa]

this should work...

<?php
  $mysql_date = '2008-03-20'; //I assume you can get this far
  print date('M j Y',strtotime($mysql_date));
?>

[Witzbold]

That worked thanks alot!

[craygo]

You can also have mysql do it for you.

 

$sql = "SELECT DATE_FORMAT(`datefield`, '%b-%d-%Y') AS `fdate` FROM `tablename`";

 

Now your formated date will be in the alias `fdate`

 

Ray