Re: Fw: Date Add
| From: | Pierre-Alain Joye | Date: | Sun, 04 Aug 2002 15:44:16 +0000 |
| Subject: | Re: Fw: Date Add | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20980@lists.php.net to get a copy of this message | ||
On Sun, 4 Aug 2002 17:42:17 +0200
Pierre-Alain Joye <paj@pearfr.org> wrote:
> On Sun, 4 Aug 2002 17:30:31 +0200
> "John Fishworld" <john@webital.de> wrote:
> For a specific day, here the current day
WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW())
if you store as date-time format :).
hth
pa