to obtain date as yyyy using substr
411033Jun 6 2006 — edited Jun 13 2006hi everybody,
i add nls_date_format 'dd-mm-yyyy' in o.s. register and selection default_home orant as a result i want to obtain 2006 using substr commands like that ;
Now in SQL*Plus, i use commnand ;
select substr(sysdate,7,4) from dual ;result ; -06
it does not use my date format
before i used this command like above and i obtained 2006. but now i don't know what happened ? have you any idea ? thanks...