sysdate incorrect
I changed the timezone of the database owner to be GMT, then I restart database and listner.
then I login sql plus and run:
select to_char(sysdate, 'yyyy-mm-dd HH24:MI:SS' from dual;
it still return me the date time in previous timezone, not GMT.
I know all of others OS users are not on GMT, but I think that should nothing to do with database, correct? sysdate should take the database owner who start database user's time zone, correct?
why the sysdate does not use the new timezone