This isn't really a PHP question, is it? This is a function of your database, and since you don't mention which database you are using it is a bit hard to answer. Assuming MySQL, there is an entire chapter in the MySQL docs on exactly how to do this:
http://www.mysql.com/doc/en/Date_and_time_functions.html If it is another database, go read the appropriate docs, or ask on a mailing list related to that database. -Rasmus On Sun, 11 Aug 2002, Kristoffer Strom wrote: > I've tried that, but as usual rtfm doesn't help me. I need concise examples > :( > > How would I write this basic select query to get the date in my format > (Saturday, August 10th, 2002)? > SELECT datum FROM news_items > (where "datum" is the date-stamp in "YYYY-MM-DD" format) > > I've tried the combo's I can think of and still get nothing on the other > side... > > /Kris > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
