-- show the old/new StartTimes
select
StartTime as 'Old StartTime',
right(convert(char(16), dateadd(hh, 1, convert(datetime, StartTime, 114)), 121), 5) as 'New StartTime',
Frequency_Type,
FrequencySubType,
Frequency,
*
from DialogSchedule
where
Frequency_Type in ('Year', 'Month', 'Week', 'Day')
-- change them to the new time
update DialogSchedule
set StartTime = right(convert(char(16), dateadd(hh, 1, convert(datetime, StartTime, 114)), 121), 5)
where
Frequency_Type in ('Year', 'Month', 'Week', 'Day')
Please make sure to have a valid database backup available before running any SQL Queries.