CREATE TABLE table_204_23 (id NUMBER, "#" NUMBER, "wrestlers" CLOB, "reign" NUMBER, "date" CLOB, "days held" NUMBER, "location" CLOB, "event" CLOB, "notes" CLOB)

how many days did hardcore tv # 6 take ?
SELECT "days held" FROM table_204_23 WHERE "event" = 'hardcore tv #6'
SELECT "days held" FROM "table_204_23" WHERE "event" = 'hardcore tv #6'