title: Adjusting for timezone and daylight saving time on a per-user basis
body: <p>I am doing an application where the users store their timezone in an SQL database.</p>
  
  <p>How do I keep track when there is daylight saving time in their locations?</p>
  
  <p>I was thinking of having a column in the users table with the users specified time zone, and then another table where i would match the user time zone with it's corresponding interval displacement regarding UTC</p>
  
  <p>But how do I do a script that automatically changes this off set for places where there is daylight saving time? There are even places when sometimes there is daylight saving and some years there is not.</p>
  
  <p>Should I use an API? If so, which one?</p>
  
  <p>Is my appoach plain wrong?</p>
  
  <p>Thank you</p>