Formatting timestamp(8) ooutput?

[Anon]

I've seen some code for this before. But I can't remember where I saw it.

When mysql outputs timestamp(8) it looks like this on my page: 20020718. Is there a way I can format it to look like: 07-18-2002?

I am a novice php coder. I haven't a clue how to use those mysql statements to do this =\

[planetphp]

You can format the date using a mysql query...

query = "date_format(date, '%d %M %Y')"

this will return:

01 January 2002

there are many ways to recall the info

%W weekday name e.g. Monday
%a weekday short e.g. Mon
%d day of month e.g. 01
%e day of month e.g. 1
%D day of month e.g. 1st
%M month e.g. January
%b Month short e.g. Jan
%Y year 4 digit 2002
%y year 2 digit 02

date being the timestamp column in your database....

Hope that helps

[Anon]

thats what i have seen before. i have no idea how to do that =(