I have Dates stored in my MySQL Database That when I display them on a .php  page I want them to be displayed in a different format.

Currently they are in
Year-month-day

I want them to be
day of the week abriv.(Tue) - month abriv.(Apr) - number day with suffic(1st)


_________________
Sarah Atkinson

I figured it out

[/code]


_________________
Sarah Atkinson

Good job with figureing this out. Its also helpful to many other people who aren't really sure how to do this, if you post exactly how you figured out the solution. I know you posted the code, but some may not be able to tell by looking at the code.

Its quite simple really, I'll explain Sarah's SQL a bit:



First off she selects the fields 'id' and the "date" by using the date_format() function which is sort of like sprintf() the php function except for its own uses %a being Day(abriv) -- %b being Month(abriv) and %D being day number with suffix.  Then she selects the return value of the date_format() function AS date_string.  Then she also limits her query down based on if day > var $x.

Hope this helps to explain it a bit more.


_________________
Software Engineer
http://www.tuxmafia.com