CREATE TABLE table_78864 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Date" CLOB)

on what date was tie number 4?
SELECT "Date" FROM table_78864 WHERE "Tie no" = '4'
SELECT "Date" FROM "table_78864" WHERE "Tie no" = '4'