Use sp_modify_time_range to:
Specify which time range to modify
Specify the change to the days of the week
Specify the change to the times of the day
For syntax and detailed information, see sp_modify_time_range in the Reference Manual.
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"
You
cannot modify the “at all times” time range.
