How can I change database date/time(Sysdate) without changing OS date
sunMay 14 2009 — edited May 16 2009Hello all,
I have a need to change the sysdate on a database for testing purposes and need to set the database date to a future date(ex. 6/30/2009). I have 2 other instances on the same server so changing the OS date is not an option. I'm familiar with setting the sysdate to a fixed value, but doing so changes the date to a constant because I still need the time to elapse. I've searched the forum and cannot find a way to do this. Any help would be greatly appreciated.
Thanks,