title: How do I properly handle timestamps using CakePHP?
body: <p>Please feel free to only answer parts of the question, whatever you might have an answer to.</p>
  
  <p>With the new 2.2 version of cake, time zones are better supported, which is perfect timing since I'm working on a very "time sensitive" app.  Try as I might though, I simply cannot get everything to work.  So here are my questions:</p>
  
  <p>Should datetime entries (think created/modified) be stored in UTC?  If so, what's the most effecient way to make sure cake uses UTC?</p>
  
  <p>Should timestamps (precise moments in time) be stored as an int or as a timestamp in mysql?</p>
  
  <p>Using the new cake, how do I automatically convert UTC int/timestamps to a default site timezone?  A user timezone (stored in their user tuple)?</p>
  
  <p>If datetime (created/modified) times are stored as UTC, how do I convert them using cake to the default site timezone?  User timezone?</p>
  
  <p>Thank you!</p>