问题描述:输入一个时间,获得当前月区间。如:输入2018/09/03 获得2018/09/01至2018/09/30
SELECT * FROM servicerecord a
WHERE a.servicetime >= trunc(sysdate,'MONTH') AND a.servicetime <= (last_day(trunc(sysdate,'MONTH'))+1)
问题描述:输入一个时间,获得当前月区间。如:输入2018/09/03 获得2018/09/01至2018/09/30
SELECT * FROM servicerecord a
WHERE a.servicetime >= trunc(sysdate,'MONTH') AND a.servicetime <= (last_day(trunc(sysdate,'MONTH'))+1)