OVERLAPS

说明

判断前后两个时间区域是否有重叠，是返回t，否返回f。

语法

overlaps ::=

overlaps ::=
    OVERLAPS ( time_expression1 , time_expression2 , time_expression3 , time_expression4 )

参数

time_expression1

time_expression2

time_expression3

time_expression4

给出的时间信息，各个参数所允许的数据类型如下所述：

为了简便起见，我们用A代表DATE类型，用B代表TIME类型，用C代表TIME WITH TIME ZONE类型，用D代表TIMESTAMP类型，用E代表TIMESTAMP WITH TIME ZONE类型，用F代表INTERVAL YEAR TO MONTH类型，用G代表INTERVAL DAY TO SECOND类型。

OVERLAPS所允许的参数类型组合为:

OVERLAPS(A,A,A,A);

OVERLAPS(A,F,A,A);

OVERLAPS(A,A,A,F);

OVERLAPS(A,F,A,F);

OVERLAPS(A,G,A,A);

OVERLAPS(A,A,A,G);

OVERLAPS(A,G,A,G);

OVERLAPS(B,B,B,B);

OVERLAPS(C,C,C,C);

OVERLAPS(D,D,D,D);

OVERLAPS(D,F,D,D);

OVERLAPS(D,D,D,F);

OVERLAPS(D,F,D,F);

OVERLAPS(D,G,D,D);

OVERLAPS(D,D,D,G);

OVERLAPS(D,G,D,G);

OVERLAPS(E,E,E,E);

OVERLAPS(E,F,E,E);

OVERLAPS(E,E,E,F);

OVERLAPS(E,F,E,F);

OVERLAPS(E,G,E,E);

OVERLAPS(E,E,E,G);

OVERLAPS(E,G,E,G);

返回值

返回bool类型的值。

示例

示例1: 用 OVERLAPS 判断两区域是否重叠

--  用 OVERLAPS 判断两区域是否重叠
SELECT OVERLAPS('12:12:12', '12:12:15', '12:12:16', '12:12:17');
OVERLAPS(boolean)      |
-----------------------
false                  |
总数目：1



SELECT OVERLAPS('12:12:12', '12:12:15', '12:12:06', '12:12:17');
OVERLAPS(boolean)      |
-----------------------
true                   |
总数目：1