When was the date of appointment for St. Johnstone's manager?
create table table_16075179_6 (date_of_appointment varchar, team varchar, PRIMARY KEY (date_of_appointment))
select date_of_appointment from table_16075179_6 where team = "st. johnstone"