I have a website that I want to migrate to DH. One issue I see, with a staged version of the site that I have, is that there are pages that show upcoming events (e.g. showing the next two upcoming events, which are stored in a database) and pages that record and then display the time (e.g. new items created).
I’m using PHP and MySQL, and am in the Eastern US timezone. With my current provider, the servers (web & database) are in the same timezone, however, DH servers are in Pacific timezone.
I searched the forums and saw a suggestion to set the timezone in the .htaccess file for PHP solution. That worked, however, the time is still off, as the time used is not accounting for daylight savings time, which we are currently in.
Is there a way to account for this (automatically)? Preferably, without having to change the scripts, where dates are used?
Note, I do have a custom php.ini file, as I needed to adjust other PHP settings. Is there a way to set the default there?
For MySQL, I have queries that use the date/time stored in a record, and compare it to NOW(). What method can I use to either set the default timezone (automatically adjusting for DST), or adjust the time (again, automatically accounting for DST)?
I’m assuming I can probably use DATE_ADD (or it’s inverse) to adjust, but I’m wondering about DST handing.
Please let me know, as it’s the last blocking item (I think :^) to migrating.