Posts Tagged ‘DOW’

Business Objects (Oracle) returns wrong day of week

Written by Ingmar Verheij on June 7th, 2011. Posted in Microsoft App-V

Days of the week

Business Objects (BO) is used to generate a report showing the schedule of employees. In the schedule the day of week is displayed as a header, which makes it easy for the employees to read. The data is retrieved from an Oracle database server.

There are two situations, one with a native Oracle installation and one with a sequenced Oracle installation.

In one situation the week starts on Sunday (zondag) in the other on Monday (maandag), resulting in a vague schedule for the employee. Although the date is correct, the corresponding day of week isn’t.