Use sp_modify_time_range to:
Specify a time range to modify
Specify changes to the days of the week
Specify changes to the times of the day
See sp_modify_time_range in the Reference Manual: Procedures.
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.
