hello i have to convert my date i. e. in dd/mm/yyyy format from 04/10/2013 to 10/04/2013.
pl temm me how to do it.....
Oracle stores the date field as mm/dd/yyyy format only in DatabaseNo, mm/dd/yyyy is a display format. The internal storage has no formatting except the ordering of bytes used to store the information.
or by passing a format mask in TO_CHAR.
SELECT * FROM nls_session_parameters WHERE parameter = 'NLS_DATE_FORMAT'
But don't do this, when the column is defined as DATE!!
i have to convert date 04/10/2013 to 10/04/2013 explicitly in my database . dates are in dd/mm/yyyy.
because of some mistakes it happens that instead of 10/04/2013 we save it 04/10/2013.