master database only
systimeranges stores named time ranges, which are used by Adaptive Server to control when a resource limit is active.
The columns for systimeranges are:
Name |
Datatype |
Description |
|---|---|---|
name |
varchar(255) |
Unique name of the time range. |
id |
smallint |
Unique identifier for the time range. 1 represents the “at all times” limit. |
startday |
tinyint |
Day of week (1 – 7) for the beginning of the range. Monday = 1, Sunday = 7. |
endday |
tinyint |
Day of week (1 – 7) for the end of the range. Monday = 1, Sunday = 7. |
starttime |
varchar(10) |
Time of day for the beginning of the range. |
endtime |
varchar(10) |
Time of day for the end of the range. |
Clustered index on id
