i want to convert the date format . The default date format in oracle is dd-mon-yy. I want that my default date format should be dd-mon-yyyy. I tried changing initorcl.ora . But it does not work.
e.g:-whenever i write "select sysdate from dual". The date format is dd-mon-yy. I want that this date format should be dd-mon-yyyy.
Although setting the nls_date_format parameter will sort out your immediate problem, it is dangerous to rely on default date formats like that (if a session runs the code without having the date format set, the code breaks - and, of course, there are portability issues). It is better to explicitly set the date format whenever the date is used by using the to_char(sysdate, 'dd-mon-yyyy') function.