I know that changing SYSDATE is only possible by changing date in OS,but tell me command,to change SYSDATE format.................:)
Printable View
I know that changing SYSDATE is only possible by changing date in OS,but tell me command,to change SYSDATE format.................:)
change nls_date_format to what you want
e.g.
alter session set nls_date_format='DD.MM.YYYY HH24:MI:SS';
Thank U Davey& Ales