CREATE TABLE table_name_46 (date VARCHAR2, home_team VARCHAR2)

What was the date of the footscray home game?
SELECT date FROM table_name_46 WHERE home_team = "footscray"
SELECT "date" FROM "table_name_46" WHERE "footscray" = "home_team"