Forum Stats

  • 3,827,149 Users
  • 2,260,746 Discussions
  • 7,897,182 Comments

Discussions

Are NLS settings dependent on Client machine settings?

Geert01
Geert01 Member Posts: 191 Bronze Badge

The reason I am asking this is that when I log in to apex.oracle.com and execute a query 

SELECT * FROM V$NLS_PARAMETERS WHERE ....

I see

As the NLS_DATE LANGUAGE is AMERICAN, I understand the mm/dd/yyyy. But why is the NLS_TIMESTAMP_FORMAT DD-MON-RR.....? I would expect that to also be MM/DD/YYYY. Is this the same for everybody (wherever you are) or does APEX look at some client (browser) settings?

Tagged: