Formatting Datetime

[Anon]

Hi, I have a column of type datetime in my table but right now I don't like how the date is formatted.

Can someone tell me how to format the date like this, if it's possible:

Wednesday, August 2, 2000

Day, Month Date, Year

Thanks!

[Anon]

Try the following code:

// Newsdate is a column from a database table

list($Year, $Month, $Day) = explode('-', $NewsDate);
$UseDate = Date("l jS F Y", mktime(0, 0, 0, $Month, $Day, $Year));

Displays a date in the following format:

Wednesday 2nd August 2000

Hope it helps.

Berb Brown

[Anon]

Is this using mysql? if so,

A better way to do this is to either use the databases built in date_format() function or change your select statement to be select unix_timestamp(newsdate) as newsdate

So you can use date("l jS F Y", $db->f("newsdate")) instead of the list function, making the code more readable.