Modifying a Named Time Range

Use sp_modify_time_range to modify time ranges, including changes to the days of the week, or times of the day.

See sp_modify_time_range in the Reference Manual: Procedures.

Note: You cannot modify the “at all times” time range.

For example, to change the end day of the business_hours time range to Saturday, retaining the existing start day, start time, and end time, enter:

sp_modify_time_range business_hours, NULL, Saturday, NULL, NULL

To specify a new end day and end time for the before_hours time range, enter:

sp_modify_time_range before_hours, NULL, Saturday, NULL, "08:00"