snowgod
06-14-2004, 02:08 PM
Hello:
I added a column to my table and I want to take an existing date from another column, add one day, and put that value into the new table. My sql doesn't error out, but it doesn't appear to change the values at all. Here is what I have:
UPDATE msat_rpt SET `rpt_edate` = (DATE_ADD('rpt_sdate', INTERVAL 1 DAY)) WHERE `rpt_category` = 'Stats';
All the searching I have done only shows date_add() with SELECT, but this seems simple enough, what am I missing?
I added a column to my table and I want to take an existing date from another column, add one day, and put that value into the new table. My sql doesn't error out, but it doesn't appear to change the values at all. Here is what I have:
UPDATE msat_rpt SET `rpt_edate` = (DATE_ADD('rpt_sdate', INTERVAL 1 DAY)) WHERE `rpt_category` = 'Stats';
All the searching I have done only shows date_add() with SELECT, but this seems simple enough, what am I missing?