Day number of the week issue

[JuanCLazaro]

Hi,

I would like to know what is the parameter that needs to be changed in order to avoid the following:

When calculating a Day number or Day literal from a date-field using BODI (DI 1, the result is not the expected, a Monday gets daynumber 2 whilst using SQL, the daynumber would be 1.

Can anyone help on this?

Thanks

[paul_kessler]

How are you applying the day_in_week() function? The following expression returns 1:

day_in_week(to_date('8-2-2010', 'mm.dd.yyyy'))