Convert DataTime

[NZ_Kiwis]

I have a datatime value being returned from my mysql database.

How can I convert it into day month year etc? something like this?

<?php
echo date('d M yy', "2011-10-18 09:25:05");
?>

[dalecosp]

The 2nd argument to [man]date/man in PHP should be a Unix Timestamp.

I don't know off the top of my head if [man]strtotime[/man] can convert that ... you might try:

echo date("d M yy",strtotime("2011-10-18 09:25:05"));

And see if that gets you want you want. Otherwise, there are various other date functions and strategies, one of which might be to ask the database to give you a Unix Timestamp instead of the DateTime it has by default, maybe like this:

$sql = "select from_unixtime(my_date_field) as timestamp from my_table;";
//do the query & etc.
echo date("d M yy",$timestamp_var);

[Weedpacket]

Another thing that could be done would be to use the dbms's date/time formatting functions to format the date in the result set it returns.

[maxxd]

If - for whatever reason - you need to do it in PHP and not the database as Weedpacket suggests, you could use the value to create a new DateTime() object, then print the format() method.

$dt = new DateTime($result['date_column']);
print("<p>".$dt->format('F j, Y g:i:s a')."</p>");