what is the date when the tie no is 9?
CREATE TABLE table_name_46 (date VARCHAR, tie_no VARCHAR)
SELECT date FROM table_name_46 WHERE tie_no = "9"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (date VARCHAR, tie_no VARCHAR) Question: what is the date when the tie no is 9? [/INST] SELECT date FROM table_name_46 WHERE tie_no = "9" </s>