How to customize the first DayOfWeek in SHR/Sybase IQ?
Setting the first day of the week is not technically a setting in SHR. This setting is at the Sybase IQ level, and changes must be made in the database.
The Sybase IQ option DATE_FIRST_DAY_OF_WEEK is, by default, 0, making Sunday the default first day of the week. This option could be set to any of the following values, as appropriate:
The following SQL code may be run in dbisql.exe to change this setting on the pmdb database:
set option DATE_FIRST_DAY_OF_WEEK = 1
Change option in this way affect only current user, so you must connect to DB as pmdb_admin user.
update datetime set
week_boundary=case when (datepart(mi,time_full_date) = 0 and
datepart(hh,time_full_date) = 0 and
datepart(dw,time_full_date) = 1) then 1
We must also recalculate week numbers to shift Sundays and Mondays to properly weeks.
update DATETIME SET TIME_WEEK_NUMBER=datepart(cwk, TIME_FULL_DATE)