Oracle Session Set Time
Posted on 2013-06-28
There is a way to set the timezone for session by using - alter session set time_zone = '+02:00'
Is there a way to set the date&time for session? The result would be that a "select sysdate from dual" would yield a value relative to the the date&time set.
The end result is that I want to set the date&time to JAN15 and run a test based on that time. I am not able to change the server time because it will impact others using the server.