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
> > thoug
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 CURREN
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, ca
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 Fri
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 My
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
6 matches
Mail list logo
