CREATE TABLE table_name_23 (date VARCHAR, time VARCHAR)

What is the Date of the Event with a Time of 2:23:47?
SELECT date FROM table_name_23 WHERE time = "2:23:47"
SELECT "date" FROM "table_name_23" WHERE "2:23:47" = "time"