date formatting

[graham23s]

Hi Guys,

when a user logs into my site mysql records the date as:

2007-04-29 22:13:42 

i was after making it say:

April 29, 2007, 22:13 pm 

how would i go about doing this?

Thanks guys

Graham

[stymiee]

date("F j, Y, H:i a", strtotime('2007-04-29 22:13:42 '))

[graham23s]

thanks mate

Graham

[felgall]

Or better yet use the appropriate mySQL command to retrieve it the way that you want rather than using PHP to convert it after retrieval.

[graham23s]

Hi Felgall,

could you tell me the command i would need to do that? that sounds good aswell (if slightly better)

this is what i did to make it convert:

         $date_format = $row["login"]; 
         $display_date = date("F j-Y-H:i a", strtotime($date_format));
echo $display_date; 

thanks mate

Graham

[barbara1712]

You can also use the select command of mysql to retrieve the date like:

select date_format(logged_on,'%M %d, %Y, %H:%i %p') as date1 from table_name