| STARTRULEDATE |
datetime |
|
|
Stores the date this rule starts |
| ENDRULEDATE |
datetime |
|
|
Stores the date this rule ends |
| ISFIXEDSTARTDATE |
bit |
|
Default = 0 |
Stores whether or not this is a fixed date rule for transition start |
| ISFIXEDENDDATE |
bit |
|
Default = 0 |
Stores whether or not this is a fixed date rule for transition end |
| STARTDAYOFWEEKCODE |
tinyint |
|
Default = 1 |
Stores day of week daylight savings time transition begins when rule is not fixed date |
| STARTDAYOFWEEK |
nvarchar(9) (Computed) |
yes |
CASE [STARTDAYOFWEEKCODE] WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' END |
Provides a translation for the 'STARTDAYOFWEEKCODE' field. |
| ENDDAYOFWEEKCODE |
tinyint |
|
Default = 1 |
Stores day of week daylight savings time transition ends when rule is not fixed date |
| ENDDAYOFWEEK |
nvarchar(9) (Computed) |
yes |
CASE [ENDDAYOFWEEKCODE] WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' END |
Provides a translation for the 'ENDDAYOFWEEKCODE' field. |
| STARTMONTHCODE |
tinyint |
|
Default = 1 |
Stores month daylight savings time transition begins when rule is not fixed date |
| STARTMONTH |
nvarchar(9) (Computed) |
yes |
CASE [STARTMONTHCODE] WHEN 1 THEN N'January' WHEN 2 THEN N'February' WHEN 3 THEN N'March' WHEN 4 THEN N'April' WHEN 5 THEN N'May' WHEN 6 THEN N'June' WHEN 7 THEN N'July' WHEN 8 THEN N'August' WHEN 9 THEN N'September' WHEN 10 THEN N'October' WHEN 11 THEN N'November' WHEN 12 THEN N'December' END |
Provides a translation for the 'STARTMONTHCODE' field. |
| ENDMONTHCODE |
tinyint |
|
Default = 1 |
Stores month daylight savings time transition ends when rule is not fixed date |
| ENDMONTH |
nvarchar(9) (Computed) |
yes |
CASE [ENDMONTHCODE] WHEN 1 THEN N'January' WHEN 2 THEN N'February' WHEN 3 THEN N'March' WHEN 4 THEN N'April' WHEN 5 THEN N'May' WHEN 6 THEN N'June' WHEN 7 THEN N'July' WHEN 8 THEN N'August' WHEN 9 THEN N'September' WHEN 10 THEN N'October' WHEN 11 THEN N'November' WHEN 12 THEN N'December' END |
Provides a translation for the 'ENDMONTHCODE' field. |
| STARTTIMEOFDAY |
UDT_HOURMINUTE |
|
Default = '' |
Stores time daylight savings time transition begins when rule is not fixed date |
| ENDTIMEOFDAY |
UDT_HOURMINUTE |
|
Default = '' |
Stores time daylight savings time transition ends when rule is not fixed date |
| STARTWEEKOFMONTHCODE |
tinyint |
|
Default = 1 |
Stores week of month daylight savings time transition begins when rule is not fixed date |
| STARTWEEKOFMONTH |
nvarchar(6) (Computed) |
yes |
CASE [STARTWEEKOFMONTHCODE] WHEN 1 THEN N'First' WHEN 2 THEN N'Second' WHEN 3 THEN N'Third' WHEN 4 THEN N'Fourth' WHEN 5 THEN N'Fifth' END |
Provides a translation for the 'STARTWEEKOFMONTHCODE' field. |
| ENDWEEKOFMONTHCODE |
tinyint |
|
Default = 1 |
Stores week of month daylight savings time transition ends when rule is not fixed date |
| ENDWEEKOFMONTH |
nvarchar(6) (Computed) |
yes |
CASE [ENDWEEKOFMONTHCODE] WHEN 1 THEN N'First' WHEN 2 THEN N'Second' WHEN 3 THEN N'Third' WHEN 4 THEN N'Fourth' WHEN 5 THEN N'Fifth' END |
Provides a translation for the 'ENDWEEKOFMONTHCODE' field. |
| STARTFIXEDDATE |
datetime |
yes |
|
Stores date (with 0001 year) daylight savings time transition starts when rule is fixed date |
| ENDFIXEDDATE |
datetime |
yes |
|
Stores date (with 0001 year) daylight savings time transition ends when rule is fixed date |
| DAYLIGHTSAVINGSDELTA |
smallint |
|
Default = ((0)) |
Stores the number of minutes difference between standard and daylight savings time |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |