v_begin_date:=to_date(to_char(sysdate,'yyyy-mm'),'yyyy-mm'); v_end_date:=v_begin_date - interval '1' MONTH; -- 执行结果:v_begin_date=2013-9-1 v_end_date=2013-8-1 select numtodsinterval(t.qzbfqz-sysdate,'day')from VEHICLE_VIEW_CXTJXT t select ceil(t.qzbfqz - sysdate)...