[macintosh]

Hey
I retrieve the date from mysql and it gives the output like

PHP Code:

2008-03-20 19:23:03 

, i want to display the date in the following format..

Code:

March 20, 2008 At 7:23 Pm

Is there any function to get that format of output?
At the moment i insert value in mysql with NOW() and the mysql column type is "datetime".

[Jay6390]

Use the strtotime() function to get the time as a unix format and then use the date() function to replace it with the correct output

Jay

[job0107]

You can convert it like this:

PHP Code:

$time="2008-03-20 19:23:03";
$tm = strtotime($time);
echo date("F j, Y \\A\\t g:i A",$tm); 

It will give you this result:

Code:

March 20, 2008 At 7:23 PM

[mab]

Using the mysql DATE_FORMAT() function in your SELECT query will result in the quickest code. No slow php code (strtotime() and date()) is needed.

[Jay6390]

Nice, hadn't seen that before. Thanks Mab. Will have to remember that one

[blinn_shade]

So Mab what is the full code?

[Jay6390]

Take a look here
http://dev.mysql.com/doc/refman/5.0/...on_date-format
Show's how to use it in a query

Also here shows you how
http://www.plus2net.com/sql_tutorial/date_format.php