Day of Week Constants (SQLDMO_WEEKDAY_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Day of week constants enumerate the days of the week.

Constant

Value

Description

SQLDMOWeek_EveryDay

127

All days

SQLDMOWeek_Friday

32

Friday

SQLDMOWeek_Monday

2

Monday

SQLDMOWeek_Saturday

64

Saturday

SQLDMOWeek_Sunday

1

Sunday

SQLDMOWeek_Thursday

16

Thursday

SQLDMOWeek_Tuesday

4

Tuesday

SQLDMOWeek_Wednesday

8

Wednesday

SQLDMOWeek_WeekDays

62

Monday, Tuesday, Wednesday, Thursday, and Friday

SQLDMOWeek_WeekEnds

65

Saturday and Sunday

SQLDMOWeek_Unknown

0

None specified