Im using php to set the current timezone for a site:
date_default_timezone_set('America/New_York');
How could I, at the same time, set the same time zone for mysql so that when I use NOW() it uses the timezone set in php?
Im using php to set the current timezone for a site:
date_default_timezone_set('America/New_York');
How could I, at the same time, set the same time zone for mysql so that when I use NOW() it uses the timezone set in php?
Don't.
The best practice is to store UTC
in the database.