DECLARE @TempStartDateTime DATETIME,@TempEndDateTime DATETIME
SET @TempStartDateTime = CONVERT(CHAR(10),GETDATE(),120)
SET @TempEndDateTime = DATEADD(DAY, + 7, @TempStartDateTime)
SET @TempStartDateTime = CONVERT(CHAR(10),GETDATE(),120)
SET @TempEndDateTime = DATEADD(DAY, + 7, @TempStartDateTime)