PHP date - format

[adammc]

Hi guys,

I am storing the date (2007-08-23 11:11:12) in a datetime field in MYSQL DB.

I wish to display it as: '23rd Aug 2007' but cant seem to achive this??
Im fetching the last login time from the Db when I log the user in and storing it in a session.

$last_login = date("Y-m-d H:i:s", $_SESSION['lastlogin']); 

Can anyone possibly help?

[adammc]

I think i got it sorted !!!!

$last_login = date('d M Y', strtotime($_SESSION['lastlogin']));

Please correct me if wrong

[Ernie1]

$last_login = date("dS M Y", strtotime($_SESSION['lastlogin'])); 

[spikeZ]

An alternative would have been to let mysql do the date conversion when it is querying for the user data.

select date_format(date_field,  '%D %M %Y') as last_login

Not really much difference, just another way