Re: How to search for a date
| From: | John W. Holmes | Date: | Thu, 05 Feb 2004 16:16:53 +0000 |
| Subject: | Re: How to search for a date | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176906@lists.php.net to get a copy of this message | ||
From: "John McKerrell" <john.mckerrell@fastwebmedia.com>
> > INSERT INTO mytable (dateField) VALUES (CURRENT_DATE);
> For MySQL you're still going to need NOW() instead of CURRENT_DATE
> though surely?
No. He has a DATE column, so why use NOW() which includes time informatin.
Quote: CURRENT_DATE and CURRENT_DATE() are synonyms for CURDATE().
Take your pick.
---John Holmes...