如何将时间日期分隔成“上半月”“下半月”
select (CASE WHEN TO_NUMBER(TO_CHAR(JYSJ,'DD'))<=15 THEN '上半月' WHEN TO_NUMBER(TO_CHAR(JYSJ,'DD'))>15 THEN '下半月' ELSE 'NULL' END) AS monfrom BFBHDD8.SKTXSJL
本文共 243 字，大约阅读时间需要 1 分钟。
如何将时间日期分隔成“上半月”“下半月”
select (CASE WHEN TO_NUMBER(TO_CHAR(JYSJ,'DD'))<=15 THEN '上半月' WHEN TO_NUMBER(TO_CHAR(JYSJ,'DD'))>15 THEN '下半月' ELSE 'NULL' END) AS monfrom BFBHDD8.SKTXSJL
转载于:https://www.cnblogs.com/uzipi/p/3191266.html