Collection Contents Index fire_triggers option [compatibility] Next PDF

SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

first_day_of_week option [database]


Sets the numbering of the days of the week.

Allowed values

1, 2, 3, 4, 5, 6, 7

Default

7 (Sunday is the first day of the week)

Remarks

The values have the following meaning:

Value Meaning
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
7 Sunday

The value specified by this option affects the result of the DATEPART function when obtaining a weekday value. You can also change the first day of week using the DATEFIRST option in the SET statement.

The value specified by this option does not affect the result of the DOW function. For example, even if the first day of the week is set to Monday, the DOW function returns a 2 for Monday.

See also

Collection Contents Index fire_triggers option [compatibility] Next PDF