title: How to update Timestamp Column where value is '0000-00-00 00:00:00' to '2020-01-01 11:28:47'
body: <p>I am trying to update Timestamp field value to some expired date and want to set it
  where values are '0000-00-00 00:00:00' But my query is not working. I have tried lot of solutions from stack overflow but none of them works</p>
  
  <p>Here is my MySql Command</p>
  
  <pre><code>update users set `subscribe_at` = '2020-01-01 11:28:47' AND `subscription_valid_upto` = '2020-01-01 11:28:47'
  WHERE `device_type` = 'I' AND `subscribe_at` = '0000-00-00 00:00:00' AND subscription_valid_upto = '0000-00-00 00:00:00'
  </code></pre>
  
  <p>Which works without errors but nothing happens , i have checked warnings and it says</p>
  
  <pre><code>Truncated incorrect DOUBLE value: '2020-01-01 11:28:47'
  </code></pre>
  
  <p>Here is my Table Data and its Structure.</p>
  
  <p><a href="https://i.stack.imgur.com/u9zdb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u9zdb.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/qupz1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qupz1.png" alt="enter image description here"></a></p>
  
  <p>Any help will be appreciated. Thanks.</p>