Thank you, even if I checked a lot the syntax, couldn't see it (too obvious).
Sorry for the time...
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 13:06 -0400 10/6/03, Franck Babin
wrote:
> >It's a syntax error. Even when I try without DATE_FORMAT:
> >
> >UDPATE activity SET activity_date = '20
At 13:06 -0400 10/6/03, Franck Babin wrote:
It's a syntax error. Even when I try without DATE_FORMAT:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no =
1 WHERE activity_date =
'2003-06-10 11:15:00' AND type_no = 1;
Ah.
Perhaps spelling UDPATE as UPDATE will fix the problem. :-
It's a syntax error. Even when I try without DATE_FORMAT:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
activity_date =
'2003-06-10 11:15:00' AND type_no = 1;
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 12:55 -0400 10/6/03, Franck Babin
wrote:
> >I have made
At 12:55 -0400 10/6/03, Franck Babin wrote:
I have made some changed but it still doesn't work:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
DATE_FORMAT(activity_date,'%Y-%m-%d %H:%i:%s') = '2003-06-10
11:15:00' AND type_no = 1;
I want to update only rows where e
I have made some changed but it still doesn't work:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
DATE_FORMAT(activity_date,'%Y-%m-%d %H:%i:%s') = '2003-06-10 11:15:00' AND type_no =
1;
I want to update only rows where equals '2003-06-10 11:15:00'
Is this formula
At 11:28 -0400 10/6/03, Franck Babin wrote:
I have this simple sql statement:
UDPATE activity
SET activity_date = '9.10.2003 10:00:00', type_no = 1
WHERE DATE_FORMAT(activity_date,'%d.%m.%Y %H:%i') = '09.10.2003 10:00'
AND type_no = 1;
I'm not able to execute the query. It seems that the
portion
your date format is not correct. It should be activity_date = '2003-9-10
10:00:00'.
-Original Message-
From: Franck Babin [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: Dummy problem with UPDATE for DATETIME field
I have this
I have this simple sql statement:
UDPATE activity
SET activity_date = '9.10.2003 10:00:00', type_no = 1
WHERE DATE_FORMAT(activity_date,'%d.%m.%Y %H:%i') = '09.10.2003 10:00'
AND type_no = 1;
I'm not able to execute the query. It seems that the
portion is not valid. is a DATETIME field.
Any
