Timezone offset on daily time window grouping using SQL

[LiYue]

Hello team,
        In DataStream API , a time offset can be specified like this:

input
.keyBy(<key selector>)
.window(TumblingEventTimeWindows.of(Time.days(1), Time.hours(-8)))

Is their any way to specify a time offset on SQL?
My sql looks like:

SELECT * from table
GROUP BY TUMBLE(`timestamp`,INTERVAL '1’ DAY)

Thanks !
LiYue
tig.jd.com