Overcoming timezone differences in MySQL Select

Question

Hi everyone,

I am trying to select entries for a current date but cannot seem to get past the issue of a 1 hour time difference between my timezone and that of the server.

I was able to overcome this by using DATE_ADD() for adding entries but now I need to do the same to SELECT them. I tried inserting SET time_zone = 'America/New_York'into my MySQL connection command but it did not appear to change anything. I am using a PDO::QUERY statement, here is my connection command:

$db = new PDO('mysql:host=localhost;dbname=nightdes_points', $dbuser, $dbpsw);

What am I missing here? Thanks!

Answer 1

I would always store data in GMT0 and on insert/update/select I would always pass (converted) GMT0 date.