Re: MySQL question
| From: | Ignatius Reilly | Date: | Mon, 22 Sep 2003 08:54:33 +0000 |
| Subject: | Re: MySQL question | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21482@lists.php.net to get a copy of this message | ||
One possible reason why it does not work is that the DAY() function does not
exist.
Use DATE_FORMAT() instead.
Ignatius
_________________________
----- Original Message -----
From: "Disko_kex" <disko_kex@swedish-mushroom.com>
To: <php-windows@lists.php.net>
Sent: Monday, September 22, 2003 10:47 AM
Subject: [PHP-WIN] MySQL question
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?