title: I want Age 0 when the date is 0 in mysql query
body: <pre><code>SELECT (GREATEST((YEAR(NOW()) - GREATEST( M.MANUFACTURING_DATE,1900)), 0))
  AS AGE,M.MANUFACTURING_DATE FROM table_name M;
  </code></pre>
  
  <p>Above is my mysql query where if i consider MANUFACTURING_DATE =0 then it results Age as 117, i want some solution where if the MANUFACTURING_DATE =0 it should result the Age as 0.</p>