What is the date of appointment when replaced by is roy hodgson?
create table table_10592536_8 (date_of_appointment varchar, replaced_by varchar, PRIMARY KEY (date_of_appointment))
select date_of_appointment from table_10592536_8 where replaced_by = "roy hodgson"