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?