sql convert datetime to day name : i want convert form datetime formate to day name but i have problem failed convert.

"Conversion failed when converting date and/or time from character string."

`SELECT DATENAME(dw, date) as date , name, date FROM kkpsurabaya`