Table schema:
CREATE TABLE table_name_46 (date VARCHAR, tie_no VARCHAR)

Question: what is the date when the tie no is 9?
SQL: SELECT date FROM table_name_46 WHERE tie_no = "9"