Re: DATETIME MySQL - using only month and date
| From: | Andrés G. Montañez | Date: | Sun, 10 Apr 2005 13:25:16 +0000 |
| Subject: | Re: DATETIME MySQL - using only month and date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39161@lists.php.net to get a copy of this message | ||
> $month_start : starting month
> $month_end : ending month
>
> $day_start : starting day
> $day_end : ending day
You could add something like this in the WHERE clause:
((MONTH(closing) >= $month_start AND DAY(closing) >= $day_start)
AND
(MONTH(closing) <= $month_end AND DAY(closing) <= $day_end))
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay