I have just updated many rows in a particular table using the following syntax:-
update table set effective_date = sysdate+1
This was then followed by a commit.
However this does not seem to have worked the dates have remained what they were previously. However there is another column that gets updated when any records are updated and this has been changed to todays date.