datetime format

[xiaawan]

hi Everyone.
Can anyone tell me how to change date format from mySql format to english like followings.

value in db is 2007-05-19 00:00:00
and I want it to be displayed in the following format.
May 19 2007
How can I achieve that.
thanks in advance.

[pbmods]

Take a look at date and strtotime.

[ianpitter]

I've been struggling with this also having entered a time with NOW() into a field called place_date and then been unable to format it.
The answer I have found which may not be the best but it works is as follows:

[code=php]
$mysqli = mysqli_connect( "localhost" , "user", "password", "db")

$get = SELECT DATE_FORMAT(pla ce_date,' %b %e %Y ' ) AS fmt_place_date
FROM table
WHERE...;

$get_res = mysqli_query($m yqsli,$get);

$date = $get_res[' fmt_place_date'];

echo $date;
[/code]

[Please use CODE tags when posting source code. Thanks! --pbmods]

This is mostly cribbed from Julie Meloni's book PHP, MySQL and APACHE which, as a beginner, I have found very useful. (I don't know whether I'm allowed to say this but it's a genuine comment from the UK, not a promotional fluff!)