데이빗의 도스 게임 자료실

 DECLARE @UTCDate datetime
  DECLARE @LocalDate datetime
  DECLARE @TimeDiff INT
  DECLARE @StartDate datetime
  DECLARE @EndDate datetime

 SET @UTCDate = GETUTCDATE()
  SET @LocalDate = GETDATE()
  SET @TimeDiff = DATEDIFF(hh, @UTCDate, @LocalDate)
  SET @StartDate = DATEADD(hh, -@TimeDiff, '2016-05-09 19:00:00')
  SET @EndDate = DATEADD(hh, -@TimeDiff, '2016-05-11 14:00:00')

 SELECT @StartDate