The date and time returned by the function SYSDATE varies when accessing the same database depending on the value of the TWO_TASK environment variable.
TWO_TASK = < connect string >
SYSDATE returns a date and time different from the date and time returned by the unix command "date".
TWO_TASK = <null>
SYSDATE returns the date and time which is the same as the date and time returned by the unix command "date".
Can anyone explain the difference given that in both cases we access the same database which resides on the same unix server from which we invoke sqlplus?
How does SYSDATE determine the date and time when the TWO_TASK environment variable is set?