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
alter session set nls_date_format='DD.MM.YYYY HH24:MI:SS';
AlesThe whole difference between a little boy and an adult man is the price of toys
Thank U Davey& Ales