DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Sysdate

Hybrid View

  1. #1
    Join Date
    Apr 2001
    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.

    Can any one shed anylight why this would happen.


  2. #2
    Join Date
    Feb 2001
    Paris, France
    strange behaviour, have you checked if there is a trigegr on this table ???
    select trigger_name, trigger_body
    from all_triggers
    where table_name = 'YOUR_TABLE';

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.