SELECT * FROM warning_form wf
where wf.start_time between trunc(sysdate,'mm') and sysdate
;
start_time 为oracle的date类型;oracle系统时间sysdate也为date类型;
此处查询start_time 介于当月初至当前时间之间的数据;
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