Query by month or by year or by specific day

I changed the RDS back to UTC, and set the ubuntu local time to UTC


wanna make it UTC+8