Re: Fw: Date Add
| From: | Pierre-Alain Joye | Date: | Sun, 04 Aug 2002 15:42:17 +0000 |
| Subject: | Re: Fw: Date Add | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20979@lists.php.net to get a copy of this message | ||
On Sun, 4 Aug 2002 17:30:31 +0200
"John Fishworld" <john@webital.de> 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 you store date as date/timestamp/... field type. You do not specify your rdbm, but seems
to be mysql ;).
hth
pa