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
quals '2003-06-10 11:15:00'
Is this formulation correct?
is really a DATETIME field.
Thanks.
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 11:28 -0400 10/6/03, Franck Babin
wrote:
> >I have this simple sql statement:
> >
> >UDPATE activity
> >SET activity_d
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, F
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:
> >
>
