mysql - stored procedure to find the day from IN parameter date -

please me find passing in parameter give day monday or else weekday. give working code stored procedure.

like example-

call check_date(1982-01-10);

gives -weekday.

create procedure p2(dt datetime ) begin

select dayname(dt);

end

run procedure below command :

call p2('2015-08-05')

result : wednesday

you have pass '1982-01-10' p2 function below : call p2('1982-01-10');

it gives output -weekday.