Query by month or by year or by specific day

[DMehaffy]

AWS RDS should be UTC unless you modify the setting. You need to convert the datetime from whatever your local TZ is to UTC before you make the query.