ORACLE常用函数

SELECT LAST_DAY('20230501') FROM DUAL
运行结果为：    23-05-31

SELECT MONTHS_BETWEEN('20230501','20230301') FROM DUAL
运行结果为：    2

SELECT (SUBSTR(20230522,1,6) || '01') FROM DUAL
运行结果为：    20230501

SELECT DECODE(LAST_DAY('20230501'),'20230501',SUBSTR('20230301',1,6) || '01' ,'20230501') FROM DUAL
运行结果为：    20230501

SELECT NVL(8,999) FROM DUAL
运行结果为：    8

SELECT NVL('',999) FROM DUAL
运行结果为：    999

SELECT TRUNC(57.32654) FROM DUAL
运行结果为：    57

SELECT TRUNC(57.32654,2) FROM DUAL
运行结果为：    57.32

SELECT TRUNC(57.32654,3) FROM DUAL
运行结果为：    57.326