How to change SYSDATE format?????

[hema]

I know that changing SYSDATE is only possible by changing date in OS,but tell me command,to change SYSDATE format.................:)

[davey23uk]

change nls_date_format to what you want

[ales]

e.g.
alter session set nls_date_format='DD.MM.YYYY HH24:MI:SS';

[hema]

Thank U Davey& Ales