MSSQL select between dates

Databases
1

I have datetimes stored in my database as

YYYY-MM-DD HH:mm:tt

SELECT * FROM press_coverage
WHERE press_coverage_date > 2000-01-01
AND press_coverage_date < 2001-01-01

ORDER BY press_coverage_date DESC

Doesn’t seem to work.

2 

select *
  from press_coverage
 where press_coverage_date > '2000-01-01'
    and press_coverage_date < '2001-01-01'
 order by press_coverage_date desc
3

Or


SELECT *
  FROM press_coverage
WHERE press_coverage_date BETWEEN '2000-01-01' and '2001-01-01'
 ORDER BY press_coverage_date DESC