Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_18795125_6 (date_of_appointment VARCHAR, position_in_table VARCHAR)

### Question ###
What was the date of appointment for the manager of the 23rd team?

### Accurate SQL ###

SELECT date_of_appointment FROM table_18795125_6 WHERE position_in_table = "23rd"