CREATE TABLE table_name_9 (date VARCHAR2, sub_total VARCHAR2)

On which day were the subtotal hours 9:30?
SELECT date FROM table_name_9 WHERE sub_total = "9:30"
SELECT "date" FROM "table_name_9" WHERE "9:30" = "sub_total"