获取当年第一天和去年最后一天、between and

select date_trunc('day',sci.xxx_date) FROM _xxx sci
where 1=1 limit 0,1;

select sci.xxx_date FROM _xxx sci
where 1=1 limit 0,1;-- 得到2019-08-05 22:29:17

select date_trunc('year',sci.xxx_date) FROM _xxx sci
where 1=1 limit 0,1;

select date_sub(date_trunc('year',TO_DATE('2019-03-01 03:00:00')),interval 1 day) from dual

select * from student where class_id between 2 and 4;包含2也包含4.