How to pass date parameter in stored procedure in mysql

I am trying to parse two date parameters from a SP to be used in the select statements where clause.

It seems that am getting an: ERROR 1292 [22007]: Incorrect date value.

Code snippet below:

create procedure db_name.sp_name[in start_date date, in end_date date]

select * from db_name.db_table
where date_column >= start_date and date_column = str_to_date[start_date, '%Y-%m-d%']
                   and date_column