Database Sysdate Isn't Increasing

PROBLEM:
-----------------

If you have difference current_timestamp with sysdate My database sysdate is not working,not increasing.Sysdate doesn't change.


SOLUTION:
-----------------

Check the parameter fixed_date.If you see any value,you have to reset parameter.


SQL>show parameter fixed_date

SQL>ALTER SYSTEM SET FIXED_DATE=NONE;




If the parameter also 'NONE'.

Check the timezone!!!!!