use [FRCOMMONLOG]
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 13:30:00')
SELECT DISTINCT p.account_id, a.nickname
FROM [FRDB].[dbo].[FR_account] AS a
INNER JOIN FR_account_log AS p ON p.account_id = a.account_id
WHERE p.date_login > @StartDate AND p.date_login < @EndDate