1,next_day(day,char)返回指定日期后的第一个工作日(由char指定)所对应的日期。 select next(sysdate,'星期五') from dual; 2,trim(char from string) 从字符串头尾部或者两端截断特定字符,参数char为要截断的字符,string为源字符串。 SQL> select trim('d' from 'ddDnabcDDAabcddddd') from dual 2 /TRIM('D'FRO ----------- DnabcDDAabc
--多谢枫の叶大师 SQL> SELECT TRIM('S' FROM 'STEVENS') AS TRIM FROM Dual;TRIM ----- TEVENSQL> -- NEXT_DAY: the date of the day of the week following a particular date SQL> SQL> SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday') 2 FROM dual;NEXT_DAY( --------- 18-SEP-06
select next(sysdate,'星期五') from dual;
2,trim(char from string)
从字符串头尾部或者两端截断特定字符,参数char为要截断的字符,string为源字符串。
SQL> select trim('d' from 'ddDnabcDDAabcddddd') from dual
2 /TRIM('D'FRO
-----------
DnabcDDAabc
SQL> SELECT TRIM('S' FROM 'STEVENS') AS TRIM FROM Dual;TRIM
-----
TEVENSQL> -- NEXT_DAY: the date of the day of the week following a particular date
SQL>
SQL>
SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday')
2 FROM dual;NEXT_DAY(
---------
18-SEP-06