title: MySQL DEFAULT CURRENT_TIMESTAMP doesn't work with timezones?
body: <p>I'm having a bizarre issue with my local MySQL server. I have a table with a created_at timestamp column set to CURRENT_TIMESTAMP by default. Everything I've read indicates that this should store the time in UTC, then convert it back to local time for display. However, it's not working right. I'm not sure if it's screwing up on the display or what, but when I read the timestamps out, it's giving me the GMT times instead of adjusting for my local timezone. This wouldn't be as big of an issue, except that NOW() <em>is</em> giving me local time, so I can't compare them properly. I feel like I'm probably missing something stupid, but what's going on here?</p>
  
  <p>If it matters, I'm running MySQL 5.5.24 under 64-bit Windows 8 (unfortunately).</p>
  
  <p>Edit:</p>
  
  <p>Poking at it some more has revealed that the timestamps are working fine when I add rows manually; it's just the rows coming from my PHP that are screwy. I guess the PHP connection must be overriding the default timezone for some reason.</p>