| http://www.w3.org/ns/prov#value | - Also, bare in mind that there is a possibility, that some other NLS setting which happens after your aplication logon, might be overwriting the NLS_DATE_FORMAT. For example, if after you have set your NLS_DATE_FORMAT, you execute ALTER SESSION SET NLS_TERRITORY = xyz, your NLS_DATE_FORMAT, which you have explicitely set before, is reset to the format that is the default one for that territory xyz.
|