Ed Curtis wrote:
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
the 'this_date' and 'future_date' fields in the same query.
UPDATE this_table SET
this_date = $this_date,
future_date = (DATE_ADD(this_date) INTERVAL 90 DAY)
Would this work?
Thanks,
Ed
UPDATE this_table SET
this_date = NOW(),
future_date = NOW() + INTERVAL 90 DAY;
This is probably along the lines of what you want..
Cheers,
Mark
--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]