oracle 创建工作日表,oracle – 在工作日截断表的函数

IF TRIM(l_day_of_week) in ('Monday','Saturday')

默认返回类型类似于CHAR(9).. 9是一周中某一天的最大长度(星期四)

所以星期一会附加空格!!除非你使用FMDAY

因此,TRIM()将删除所有填充的尾随空格！

您可以使用’FM'(Format Mask)试用下面的演示

随着FM

SQL> select to_char(sysdate+level,'Day'),length(to_char(sysdate+level,'Day')) as length from dual

2 connect by level <= 7;

TO_CHAR(SYSDATE+LEVEL,'DAY') LENGTH

------------------------------------ ----------

Tuesday 9

Wednesday 9

Thursday 9

Friday 9

Saturday 9

Sunday 9

Monday 9

7 rows selected.

随着FM

SQL> select to_char(sysdate+level,'FMDAY'),'FMDaY')) as length from dual

2 connect by level <= 7;

TO_CHAR(SYSDATE+LEVEL,'FMDAY') LENGTH

------------------------------------ ----------

TUESDAY 7

WEDNESDAY 9

THURSDAY 8

FRIDAY 6

SATURDAY 8

SUNDAY 6

MONDAY 6

7 rows selected.

最后,

l_day_of_week = to_char(sysdate,’DaY’)

会这样,你保存一个动态SQL调用！