How to change Oracle database sysdate to a specific date for testing purpose?

smallwei 7:59 am on October 17, 2009 | Answers: 1    
Tags: database (51), date (9), oracle (136), oracle database (11), sysdate, testing (39)

Rate Knowledge:

 Loading ...

• smallwei 7:59 am on October 17, 2009
  

  To set:
  ALTER SYSTEM SET fixed_date = ‘2009-07-14-10:00:00′;
  To unset:
  ALTER SYSTEM SET FIXED_DATE=NONE;