title: Datatype/structure to store timezone offset in MySQL
body: <p>Which would be the proper datatype/structure to store timezone offsets in MySQL? I just want to store the numeric value (the city and country are obviously stored in other columns).</p>
  
  <p>Examples:</p>
  
  <ul>
  <li>-5:00 Guayaquil, ECU</li>
  <li>-4:30 Caracas, VEN</li>
  <li>0:00 Some city</li>
  <li>2:00 Bonn, GER</li>
  </ul>