title: What's the best way to manage dates across PHP, MySQL, etc?
body: <p>My server is in Dallas.  I'm in New York City.. and both PHP and MySQL have configuration variables for setting the timezone.</p>
  
  <p>How do I get them all to work together?  What dates should I store in MySQL?  How do I get PHP to handle changing the date based on the user's preference?</p>
  
  <p>Bear in mind:  I don't think I'm ever having PHP explicitly set the date, it's always using "NOW()" in queries.. however I foresee the need to do this.  How would this be done?</p>
  
  <p>I'm hoping SO's experience can help me out here.</p>