Try the following to address the DST issue:
*******************************************************
--Returns today's date
DECLARE @todayLocalDate DATE
SET @todayLocalDate = GETDATE()
--Determines how many hours we are off from UTC
DECLARE @dateTimeOffset DATETIMEOFFSET
SELECT @dateTimeOffset = CONVERT(VARCHAR(50), CAST(SYSDATETIMEOFFSET() AS DATETIMEOFFSET(0)), 126)
--Converts to a string variable and chops off everything but the hours difference between PST and UTC.
--'7:00' during DST, '6:00' after
DECLARE @TZString VARCHAR(50)
SET @TZString = RIGHT(@dateTimeOffset,4)
--Defines a string value that can be used to populate the DATEDIFF for @ThisMorning
DECLARE @TZOffset VARCHAR(50)
SET @TZOffset = CASE @TZString
WHEN '7:00' THEN '17:00:00'
ELSE '16:00:00'
END
USE MDB;
************************************
Then in the SELECT statement convert the date, i.e.:
CONVERT (VARCHAR(19),(DateAdd(ss, CR.open_date, '1969-12-31 '+@TZOffset))) AS "Open Date"
You'll just need to update the case statement to match your time zone.