3 Replies Latest reply on Aug 4, 2010 5:54 AM by P.Forstmann

    Date format in Oracle 10g XE

      I'm using Oracle 10g XE on Windows Vista and I'm curious as to what determines the date format.

      According to the globalization section in the Oracle installation guide the NLS_DATE format is dependent on the NLS_LANGUAGE setting. In my database the NLS_LANGUAGE is American, the NLS_TERITORY is America and all other NLS_* parameters are blank (default).

      From that I would expect the default date format to be mon-dd-yyyy.

      However when I run SELECT sysdate FROM dual the date is reported as dd/mm/yyyy and this was the default format when I used SQL Developer and when I used the command line SQL*Plus. Obviously something else is determining the date format, but what?