Format date from datetime field

[3rdvalve]

I am sorry if this is a simple thing, but I have spent hours trying to work it out.

I am building a database of events and use a 'datetime' field to store the date and time of each event, along with a few text fields for other details.

The problem is, the format "2004-10-12 19:30:00" for the date and time of the event (i.e. the generic 'datetime' format) is very unfriendly and I want to present it like this:
"Tuesday 12 October 2004, 7:30 PM"

I suspect a PHP function would be better, but I have tried both PHP and MySQL functions and don't seem to be able to get it right.

I think I found I found a way if the only thing I wanted to select was the date. My queries need to be "SELECT *...." because I need all the details of the event to be shown.

I know I could cheat by writing the date as text fields, but then I would lose the functionality to Order properly or to select by date range.

Most grateful for any help...

[stew]

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

[3rdvalve]

Thanks Stew

That's one of the most confusing pages I have seen. I spent hours on it earlier trying all permutations of the lists of things. It doesn't answer my question because it doesn't answer how to build the mysql_query I want in PHP and seems to refer to date() which return the system date, not a fixed date.

B

[stew]

ok, you could try

date("r", strtotime("$datefield"));

check [man]date[/man] for the different formats that date can take... but im sure you already have!

[3rdvalve]

Hi Stew

It worked!

That's exactly what I wanted.

:p

Many thanks

3v