笔记
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’)))=0thento_char(add_months(trunc(sysdate,‘mm’),-2),‘原创 2020-08-27 23:34:42 · 187 阅读 · 0 评论 -
输入日期返回季度第几月份
selectmod(参数,3) monthfrom dual1当参数是数字型年月select mod(to_number(substr(to_char(202007),-2)),2)from dual2 当参数是字符型年月select mod(to_number(substr(‘202007’,-2)),3)from dual3 当参数是日期型年月selectmod(to_nunber(to_char(sysdate,‘mm’)),3)from dual...原创 2020-08-26 23:37:08 · 190 阅读 · 0 评论 -
oracle之字符串拆分
CREATE TABLE zylemp (ename VARCHAR2(50))INSERT INTO zylemp VALUES(‘中国’);INSERT INTO zylemp VALUES(‘中国/湖北’);INSERT INTO zylemp VALUES(‘中国/湖北/黄冈’);INSERT INTO zylemp VALUES(‘中国/湖北/黄冈/武穴’);SELECT * FROM zylempSELECT SUBSTR(ename,1,CASE WHEN INSTR(enam原创 2020-07-29 07:26:46 · 128 阅读 · 0 评论