MySQL date ranges are working as expected

I can use some help with MySQL data in Grafana. I have a table that contains stock and the date goes from 2007-01-02 to 2007-03-15. But when I select the last six months it returns 2007-01-02 to 2007-03-14 (note I don’t have this problem when the data is stored in Google Sheets? Thanks for your time.

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Hi @davidjayjackson,

Thanks for opening this post.

I think this might be related to the Grafana configuration for the default timezone.

Please check this documentation link and see if you have the correct time zone defined.