title: mysql : error 1265 data truncated for column 'due_date' at row1
body: <p>I am trying to insert data into <code>book_loans</code> where <code>date_out</code> and <code>due_date</code> are dates.</p>
  
  <p>Following is the query which I try to run but for <code>due_date</code>:</p>
  
  <pre><code>insert into book_loans(book_id2,branch_id1,card_no,date_out,due_date)
          values ('1565927699',4,9021, current_date(), current_date()+14)
  </code></pre>
  
  <p>it shows '0000-00-00' in due_date and the warning: <code>error 1265 data truncated for column 'due_date' at row1</code>.</p>
  
  <p>I tried using <code>getdate()</code> but it gives an error of library does not exist.
  what can be the problem?</p>