Time & Date offset correction does not occur in Blesta 4.11.2 (E.g. When the timezone is not UTC, but UTC+7, the report would still be based on UTC)

[Tjw]

Hi Paul, I am currently on Blesta 4.11.2.  I was using timezone UTC +7 in the setting, and when I am trying to generate a report from the database, somehow it picks up UTC timezone.

So, my report would be off by 1 day. For example, If I was looking for invoices starting from 1 July - 31 July. The report would not pick up the invoice created on July 1, since the database would show that invoice was created on June 30 at 17:00 hours, instead of July 1 at  00:00 hours. The difference is exactly +7 hours.

From what I understand Blesta stores all dates in UTC in the database, then based on the timezone in the settings, it would offset them to fetch based on the appropriate date & time. So I assume it might be possible that the offset correction does not occur anywhere in Blesta 4.11.2. 

Please look into this. Thanks.

[Paul]

1 hour ago, Tjw said:

Hi Paul, I am currently on Blesta 4.11.2.  I was using timezone UTC +7 in the setting, and when I am trying to generate a report from the database, somehow it picks up UTC timezone.

So, my report would be off by 1 day. For example, If I was looking for invoices starting from 1 July - 31 July. The report would not pick up the invoice created on July 1, since the database would show that invoice was created on June 30 at 17:00 hours, instead of July 1 at  00:00 hours. The difference is exactly +7 hours.

From what I understand Blesta stores all dates in UTC in the database, then based on the timezone in the settings, it would offset them to fetch based on the appropriate date & time. So I assume it might be possible that the offset correction does not occur anywhere in Blesta 4.11.2. 

Please look into this. Thanks.

Which report(s) is this? Timezone offset likely occurs in the majority of locations in Blesta, so if it's not occurring in a specific location we can take a look, we just need to know where.