Table: capital_punishment_connecticut
Columns: year
date
name
race
method
offense

Question: When was the date in 1786?
SQL: SELECT "date" FROM capital_punishment_connecticut WHERE "year" = 1786