We have an installation of Amelia that is working fine, but it was mistakenly installed on a server with the WordPress timezone set to GMT/UTC - which is incorrect for our region.
While it is working OK as is, we'd like to change the timezone to our local one, but of course this causes all the times of appointments to appear to update.
It looks like to make this happen I'll have to update the appointment times manually to reflect the timezone difference.
I just wanted to confirm my understanding that the time fields in the appointment table in the database - e.g., bookingStart and bookingEnd - are stored in GMT/UTC time? So simply adjusting these fields (and I guess any other time fields) to make them reflect UTC should be all I need to do?
Alternatively if there are any better ways to approach this please let me know.
That is correct, once you change your WordPress time zone, Amelia's times will change to.
Also, the default database settings are GMT. That can be changed, but I doubt it was changed unless you asked that from your hosting provider. So all the times you see there are in GMT.
Hi,
We have an installation of Amelia that is working fine, but it was mistakenly installed on a server with the WordPress timezone set to GMT/UTC - which is incorrect for our region.
While it is working OK as is, we'd like to change the timezone to our local one, but of course this causes all the times of appointments to appear to update.
It looks like to make this happen I'll have to update the appointment times manually to reflect the timezone difference.
I just wanted to confirm my understanding that the time fields in the appointment table in the database - e.g., bookingStart and bookingEnd - are stored in GMT/UTC time? So simply adjusting these fields (and I guess any other time fields) to make them reflect UTC should be all I need to do?
Alternatively if there are any better ways to approach this please let me know.
Thanks!
Hello David
Thank you for your purchase.
That is correct, once you change your WordPress time zone, Amelia's times will change to.
Also, the default database settings are GMT. That can be changed, but I doubt it was changed unless you asked that from your hosting provider. So all the times you see there are in GMT.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables