SELECT * FROM "СОРЕВН";

SELECT *
FROM   "СОРЕВН"
where  "ВРЕМЯ_ПРОВЕД" between to_date('2016/11/01', 'yyyy/mm/dd')
                          and to_date('2016/11/10', 'yyyy/mm/dd');