between と 比較演算子

select * from user where birthday > '1984-02-19' and birthday < '1986-04-08';

と、

select * from user where birthday between '1984-02-19' and '1986-04-08';

は同じです。