How to Override SYSDATE function in Oracle9i
How do I override SYSDATE function in Oracle9i Rel2. I need to mimic SYSDATE function to return a preset or offset value, without touching the DB Server Date. I need to be able to change the Database clock independent to Server date on which the Database is running.
How to Override SYSDATE function in Oracle9i
But the Fixed_date changed my init parameter file. I need something at session level. Even if the value is fixed, that's fine for me. But it should not affect the other dabase sysdate based processes like mon processes. I need to alter the session to override SYSDATE.
Please let me know whether this is possible.
Feature something like this would have beed used during Y2K testing days.