Search the Community
Showing results for tags 'timezone'.
Found 2 results
-
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. -
Hello, I'm not sure whether this is working as designed or something else. I noticed that the value of datetime field in the database are all in UTC thus causing whenever I do direct analysis to the database from external application, the time values are shifted. e.g. currently both my php and database timezones are set in: UTC+0700, and now is: [2016-04-16 13:00:00], but whenever I add someting (client or notes), the value in the database for date_added became [2016-04-16 06:00:00]
