Hi I have the following information in my SQL table:

SELECT \* FROM `table`

```
id          epic                    bid     offer   update_time
136449187   CS.D.EURGBP.TODAY.IP    7010.9  7011.9  1447854279749
136449186   CC.D.LCO.USS.IP         4430.1  4433.1  1447854279696
136449185   CS.D.USDJPY.TODAY.IP    12344.1 12344.9 1447854279679
136449184   CC.D.RB.USS.IP          12507   12527   1447854279636
136449179   IX.D.DAX.DAILY.IP       10955   10956   1447854279597
136449183   CS.D.COPPER.TODAY.IP    4610.8  4620.8  1447854279593
136449182   CC.D.HO.USS.IP          13969   13989   1447854279561
136449181   CS.D.EURCHF.TODAY.IP    10837.7 10839.7 1447854279559

```

where update\_time is a UTC epoch (integer)

how would I be able to extract only the rows that fall between 2015-11-18 08:00:00 (Europe) and 2015-11-18 21:30:00 (Europe)

Im not sure how to convert a local timestamp into the UTC equivalent in MYSQL so that I can extract the relevant rows.