查找月的第一天,最后一天selecttrunc(trunc(sysdate'month-1'
2,求所在月最后一天 last_day语句:selectlast_day(sysdate)fromdual
select trunc(sysdate'mm rownum-1 from dual connect by rownum
select sysdate from dual;alter session set nls_date_format'
html trunc函数用法如下 select trunc(sysdate from dual 2020