mysql does not respect the where of utc dates

0

I'm trying to make a query to return the records of a given month, but mysql returns records from the previous month, eg:

SELECT CREATE_TIME FROM SALE_ORDER WHERE
CREATE_TIME >= ('2016-09-01 00:00:01') AND
CREATE_TIME <= ('2016-09-30 23:59:59') 
ORDER BY CREATE_TIME

and it returns me:

  

2016-08-31 21:02:19

The bank is in amazon, and the timestamp is utc.

Any tips?

    
asked by anonymous 07.12.2016 / 17:20

0 answers