Re: How to search for a date
| From: | Duncan Hill | Date: | Thu, 05 Feb 2004 16:00:50 +0000 |
| Subject: | Re: How to search for a date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-176905@lists.php.net to get a copy of this message | ||
On Thursday 05 February 2004 15:45, Brian Dunning wrote:
> Sorry this is such a basic question - but I couldn't find it online.
>
> I have a date field in MySQL: 0000-00-00. I'm trying to insert or
> search for the current date, and I can't find the way to state that in
> the SQL. This is wrong, can someone please tell me what's correct?
>
> INSERT INTO mytable (dateField) VALUE (CURRENT_DATE);
>
> SELECT * FROM mytable WHERE dateField = CURRENT_DATE;
NOW() is the mysql function for the current date.