On Sun, 4 Aug 2002 17:42:17 +0200
Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:
> On Sun, 4 Aug 2002 17:30:31 +0200
> "John Fishworld" <[EMAIL PROTECTED]> wrote:
> For a specific day, here the current day
WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW())
if yo
On Sun, 4 Aug 2002 17:30:31 +0200
"John Fishworld" <[EMAIL PROTECTED]> wrote:
Why not simply does the where clause like :
for a whole month, here is july:
WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7'
For a specific day, here the current day
WHERE t_event_date=NOW()
That means yo
