weixin_46747995的博客

返回月度区间 select to_char(trunc(sysdate，‘mm’)，‘yyyy/mn/dd’) ||’~’||to_char(last_day(trunc(sysdate)),‘yyyy/mm/dd’) from dual 返回季度区间 select case when mod(to_number(to_char(trunc(sysdate,‘mm’),‘yyyy/mm/dd’)))=0 then to_char(add_months(trunc(sysdate,‘mm’),-2),‘

select mod(参数,3) month from dual 1当参数是数字型年月 select mod(to_number(substr(to_char(202007),-2)),2) from dual 2 当参数是字符型年月 select mod(to_number(substr(‘202007’,-2)),3) from dual 3 当参数是日期型年月 select mod(to_nunber(to_char(sysdate,‘mm’)),3) from dual ...

CREATE TABLE zylemp ( ename VARCHAR2(50)) INSERT INTO zylemp VALUES(‘中国’); INSERT INTO zylemp VALUES(‘中国/湖北’); INSERT INTO zylemp VALUES(‘中国/湖北/黄冈’); INSERT INTO zylemp VALUES(‘中国/湖北/黄冈/武穴’); SELECT * FROM zylemp SELECT SUBSTR(ename,1,CASE WHEN INSTR(enam