1
FUNCTION
IS_SAME_WEEK(
2 P_DATE1 IN DATE, -- 时间1
3 P_DATE2 IN DATE -- 时间2
4 ) RETURN BOOLEAN
5 IS
6 V_DATE1 DATE;
7 V_DATE2 DATE;
8 BEGIN
9
10 SELECT NEXT_DAY( P_DATE1 , 2 ) INTO V_DATE1 FROM DUAL;
11 SELECT NEXT_DAY( P_DATE2 , 2 ) INTO V_DATE2 FROM DUAL;
12
13 IF V_DATE1 - V_DATE2 = 0 THEN
14 RETURN TRUE;
15 END IF ;
16
17 RETURN FALSE;
18 END IS_SAME_WEEK;
2 P_DATE1 IN DATE, -- 时间1
3 P_DATE2 IN DATE -- 时间2
4 ) RETURN BOOLEAN
5 IS
6 V_DATE1 DATE;
7 V_DATE2 DATE;
8 BEGIN
9
10 SELECT NEXT_DAY( P_DATE1 , 2 ) INTO V_DATE1 FROM DUAL;
11 SELECT NEXT_DAY( P_DATE2 , 2 ) INTO V_DATE2 FROM DUAL;
12
13 IF V_DATE1 - V_DATE2 = 0 THEN
14 RETURN TRUE;
15 END IF ;
16
17 RETURN FALSE;
18 END IS_SAME_WEEK;