Re: MySQL question
| From: | Sek-Mun Wong | Date: | Mon, 22 Sep 2003 09:58:08 +0000 |
| Subject: | Re: MySQL question | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21481@lists.php.net to get a copy of this message | ||
of course this is a php newsgroup :)
try DAYOFMONTH
DAY is only available in mysql 4.1.1
"Disko_kex" <disko_kex@swedish-mushroom.com> wrote in message
news:001201c380e6$1d6caa40$e900a8c0@lokalguirdcfee...
Hi
SELECT RegDate FROM table WHERE month(RegDate) = '10' // this is
working
SELECT RegDate FROM table WHERE day(RegDate) = '2' // why isn´t this
working?