Sorry this is such a basic question - but I couldn't find it online.
I have a date field in MySQL: -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
From: Brian Dunning [EMAIL PROTECTED]
Subject: [PHP] How to search for a date
A date? Well, you could try Friendster or orkut to find date, or... oh
wait...
Sorry this is such a basic question - but I couldn't find it online.
I have a date field in MySQL: -00-00. I'm trying to insert
For MySQL you're still going to need NOW() instead of CURRENT_DATE
though surely?
John
On Thu, 2004-02-05 at 15:57, John W. Holmes wrote:
From: Brian Dunning [EMAIL PROTECTED]
Subject: [PHP] How to search for a date
A date? Well, you could try Friendster or orkut to find date, or... oh
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: -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
From: John McKerrell [EMAIL PROTECTED]
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
apologies
* scurries away and hides in a hole ;)
John
On Thu, 2004-02-05 at 16:16, John W. Holmes wrote:
From: John McKerrell [EMAIL PROTECTED]
INSERT INTO mytable (dateField) VALUES (CURRENT_DATE);
For MySQL you're still going to need NOW() instead of CURRENT_DATE
though surely?
6 matches
Mail list logo