oracle的between用来判断时间区间

SELECT * FROM warning_form wf
where wf.start_time between trunc(sysdate,'mm') and sysdate
;

start_time 为oracle的date类型;oracle系统时间sysdate也为date类型;

此处查询start_time 介于当月初至当前时间之间的数据;

原文地址:https://www.cnblogs.com/YuyuanNo1/p/9232265.html