title: MySQL Stored Procedure parsing date parameter to be used in select statement
body: <p>I am trying to parse two date parameters from a SP to be used in the select statements where clause.</p>
  
  <p>It seems that am getting an:
  ERROR 1292 (22007): Incorrect date value.</p>
  
  <p>Code snippet below:</p>
  
  <pre><code>create procedure db_name.sp_name(in start_date date, in end_date date)
  
  select * from db_name.db_table
  where date_column &gt;= start_date and date_column &lt;= end_date;
  </code></pre>
  
  <p>Please advise. Thanks a bunch in advance.</p>