Chnage date format

TCovert

How would I pull a date from the database, and then reformat it for display?

For instance: I want to pull a date that is formatted "2002-10-03" and reformat it for display as "Thursday, Oct 03"

???

Any ideas?

weekender

most people would store a date as a unix timestamp, but if you haven't, you can convert a date to a timestamp using strtotimestrtotime.

Then, you can use date() to format the timestamp as to how you want it.

The links above will take you to the relevant help pages for these functions on www.php.net

bobthedog

Or of course you can let MySQL do the work again for you (if you have stored it as a datetime field in the database)

UNIX_TIMESTAMP(column) will convert to a unix timestamp value.

TCovert

How would I then convert the timestamp to : "Thursday, Oct 03" ??

metin

Don't you read the manuall?
Here:

// for any date format
$date = '2002-10-4';
$newdate = date("D, M j ",strtotime($date));
echo $newdate."<BR>";

//... or for unix time stamps:
$unix_time_stamp = 1033682963;
$newdate = date("D, M j ", $unix_time_stamp);
echo $newdate."<BR>";

weekender

TCovert, read the manual. I gave you the links so that you could have a look and learn for yourself - in my opinion, that is the fun of coding - and this is a fairly simple question if you read the manual.

You can download it from www.php.net or just add a function name to www.php.net and it will take you to the page eg www.php.net/getdate

ok?