Selecting where timestamp greater than with timezone

Question

Suppose I have this table structure:

                          Table "test"
     Column     |            Type             | Modifiers
----------------+-----------------------------+-----------
 uuid           | uuid                        | not null
 created        | timestamp without time zone | not null

How would I select records after a certain date? But also factor in a specific timezone?

Since created is timestamp without zone, we can assume it's UTC

Example query:

select uuid from test where created >= '2017-07-20'

This would return all events that happend on, or after 2017-07-20 00:00:00.000 UTC How would I query for events that happend after say, 2017-07-20 00:00:00.000 GMT+2 ? Without having to add hours to my argument in created > arg

Answer 1

select uuid
from test
where created > '2017-07-20'::timestamp with time zone at time zone '+02';