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

Thread: Sysdate

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

    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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