Re: How to search for a date
| From: | John McKerrell | Date: | Thu, 05 Feb 2004 16:31:41 +0000 |
| Subject: | Re: How to search for a date | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176908@lists.php.net to get a copy of this message | ||
apologies
* scurries away and hides in a hole ;)
John
On Thu, 2004-02-05 at 16:16, John W. Holmes wrote:
> 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...