CREATE TABLE table_name_94 (date VARCHAR2, scorers VARCHAR2)

What date was the game played in where hegarty was the scorer?
SELECT date FROM table_name_94 WHERE scorers = "hegarty"
SELECT "date" FROM "table_name_94" WHERE "hegarty" = "scorers"