1、指定日期月第一天:
select to_char(trunc(to_date('201806','yyyymm'),'mm'),'yyyymmdd') from dual;
2、指定日期月最后一天
select to_char(last_day(to_date('201806','yyyymm')),'yyyymmdd') from dual;
3、系统日期当月第一天
方法一: select to_char(sysdate,'yyyymm')||'01' from dual;
方法二:select to_char(trunc(sysdate,'mm'),'yyyymmdd') from dual;