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

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'