All pastes #411013 Raw Edit

Something

public text v1 · immutable
#411013 ·published 2007-03-26 20:15 UTC
rendered paste body
select restaurant_id FROM schedule WHERE DATEPART(hh, GETDATE()) - DATEPART(hh, first_pickup) = (SELECT name,
  CASE time_zone
	when 'Eastern Time' Then 0
	when 'Central Time' Then -1
	when 'Mountain Time' Then -2
    when 'Pacific Time' Then -3
  end
FROM restaurant)