stored procedure to find the day from IN parameter date

please help me to find the passing IN parameter that give the day is Monday or else an weekday. give the working code for this stored procedure.

via Chebli Mohamed