Silmara,
Thursday, November 07, 2002, 10:05:37 PM, you wrote:
S> I executed the following statement:
S> UPDATE Table1
S> SET date_adm=date_adm+2
S> where date_adm='2002-10-30';
S> the result was...-00-00
S> I´m working with Mysql-max-nt 3.23.39.
S> What´s wrong?
Use DATE and TIME function
20021030 + 2 = 20021032
That is not a valid date.
You can't use regular math functions on dates.
Check out the date and time functions in the manual.
Silmara wrote:
I executed the following statement:
UPDATE Table1
SET date_adm=date_adm+2
where date_adm='2002-10-30';
the result was...-00-0
I executed the following statement:
UPDATE Table1
SET date_adm=date_adm+2
where date_adm='2002-10-30';
the result was...-00-00
I´m working with Mysql-max-nt 3.23.39.
What´s wrong?
best regards,
Sil
-
Before posting, plea
