Re: Tried that..
| From: | Rasmus Lerdorf | Date: | Sun, 11 Aug 2002 01:28:44 +0000 |
| Subject: | Re: Tried that.. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111992@lists.php.net to get a copy of this message | ||
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
>