title: Zend_Db_Expr('NOW()') and datetime in Mysql
body: <p>So I am having a strange problem on live website, and I am not sure what is causing the problem since in datetime field in mysql table sometimes time is mapped and more often it isn't. However date is always mapped.</p>
  
  <p>Code goes like this:</p>
  
  <pre><code>   $party_system_id = $this-&gt;blabla-&gt;addUser($username, 'None', 'None', '',
     $email,$promo_code,$distributor_id);
  
      if ($party_system_id!=0){
  
      $loginToken = md5(uniqid(rand(), true));    
  
          $params = array(
              'sponsorId' =&gt; $sponsor_id,
              'refferalId' =&gt; $referral_id,
              'accountType' =&gt; $type,
              'email' =&gt; $email,
              'username' =&gt; $username,
              'password' =&gt; md5($password),
              'firstName' =&gt; 'n/a',
              'lastName' =&gt; 'n/a',
              'expires' =&gt; $expiration_date,
              'activated' =&gt; 1,
              'gender' =&gt; $gender,
              'languageId' =&gt; 38,
              'onlineStatus'=&gt; 0,
              'status' =&gt; 5,
              'dateAdded' =&gt; new Zend_Db_Expr('NOW()'),
              'blaId' =&gt; $party_system_id,
      'loginToken' =&gt; $token,
              'termsAccepted' =&gt; 1
          );
  
          return $this-&gt;insert($params);
  
      }
  </code></pre>
  
  <p>And registration is allways fine, but like I said for lot of users insted of:
  <strong>2012-05-16 10:20:33</strong> I would get: <strong>2012-05-16 00:00:00</strong> and of-course it is not 00:00:00 at the moment of registration :)</p>
  
  <p>I am not sure what can be a problem, mysql, script structure, or Zend_Db_Expr. I also don't have an idea how to properly debug this, but all suggestions are more then welcome :)</p>