OBIEE 11g FAQ: Can You Change The Order of Days In The 'DAYOFWEEK' Function Based On The OBIEE NLS Setting?

(Doc ID 1632663.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


You are using DAYOFWEEK ( Day of Week ) function in OBIEE 11g (

You see 1 for Sunday, 2 for Monday, 3 for Tuesday, 4 for Wednesday, 5 for Thursday, 6 for Friday and 7 for Saturday as the result. However, you want to see 1 for Monday, 2 Tuesday and so on for the result depending on which language you start OBIEE with.  Normally the NLS setting would change this, however it does not for this function.

How can you resolve this in OBIEE 11g?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms