BETWEEN DATEADD(Hour , -1, GETDATE()) AND GETDATE() , providing Incorrect Data

Difference in Time Zone = CAN cause conflict

if you want to do something with date1 and date2 like are they both equal
both should be in the same time zone

convert ( date1 into timezone123 ) = convert ( date2 into timezone123)