If you don't really want to alter the session, you should be able to get the date format you want with the to_char function:

select to_char(sysdate, 'RRRR-MM-DD HH24:MI:SS') from dual;
[download]

Trek