计算所在月的第一天,
>>select cast(date_trunc('month',current_date) as date) from dual;
(EXPR)
----------
2017-05-01
计算所在月的最后一天(需先计算下个月第一天再减去一天),
>>select cast(dateadd(day,-1,date_trunc('month',add_months(current_date,1))) as date) from dual;
(EXPR)
----------
2017-05-31