title: mysql NOW() return wrong value whereas global timezone is set +00:00
body: <p>since 2 weeks I puzzled over timezone issue, everything working fine on my localhost BUT it returns wrong value on dedicated server. Let me tell what i have done so far.</p>
  
  <p>First set global timezone by below query: ( Super privilege both on localhost and server )</p>
  
  <pre><code> SET GLOBAL time_zone = '+00:00';
  </code></pre>
  
  <p>now run below query  to cross check whatever done</p>
  
  <pre><code>SELECT NOW(),@@global.time_zone AS gtz,@@session.time_zone AS stz,
         TIMEDIFF(NOW(), CONVERT_TZ( NOW() , @@session.time_zone ,  '+00:00' ) )
         AS OFFSET;
  </code></pre>
  
  <p>but it display different results on local and dedicated server</p>
  
  <h3>on localhost (192.168.x.x) mysql version : 5.5.8</h3>
  
  <pre><code>+---------------------+--------+--------+----------+
  | NOW()               | gtz    | stz    | OFFSET   |
  +---------------------+--------+--------+----------+
  | 2012-07-02 07:06:55 | +00:00 | +00:00 | 00:00:00 |
  +---------------------+--------+--------+----------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <h3>on dedicated server (182.168.x.x) mysql version :5.1.53-log</h3>
  
  <pre><code>+---------------------+--------+--------+----------+
  | NOW()               | gtz    | stz    | OFFSET   |
  +---------------------+--------+--------+----------+
  | 2012-07-02 12:37:59 | +00:00 | +00:00 | 00:00:00 |
  +---------------------+--------+--------+----------+
  </code></pre>
  
  <p>My question is</p>
  
  <blockquote>
    <p>why <strong>NOW()</strong> gives  wrong time ( above is IST )  whereas
    timezone is set to +00:00 ?</p>
  </blockquote>
  
  <p><strong>side note :</strong> </p>
  
  <p>I run below query  </p>
  
  <pre><code>SHOW VARIABLES LIKE '%time%zone%';
  </code></pre>
  
  <h3>on localhost</h3>
  
  <pre><code>+------------------+---------------------+
  | Variable_name    | Value               |
  +------------------+---------------------+
  | system_time_zone | India Standard Time |
  | time_zone        | +00:00              |
  +------------------+---------------------+
  </code></pre>
  
  <h3>on server</h3>
  
  <pre><code>+------------------+---------------------+
  | Variable_name    | Value               |
  +------------------+---------------------+
  | system_time_zone | GMT+5               |
  | time_zone        | +00:00              |
  +------------------+---------------------+
  </code></pre>
  
  <blockquote>
    <p>does this will affect the result? OR</p>
    
    <p>is there any bug in earlier version of mysql ?</p>
  </blockquote>
  
  <p>please help me. </p>