DB2中 between and 的边界

在DB2是中经过测试发现：

between and ==    >=  and <

eg:

SELECT *
FROM TB2096_51
WHERE PARTY_ID ='7590950f99d34410b123ad3821a5965e'
AND CUST_LEVEL_FACTOR='200000000050'
AND FACTOR_VAL_CHG_QTY=0
--AND CREATED_TIME >= '2015-05-18 18:49:52' and CREATED_TIME <'2015-05-18 18:49:53'
        AND CREATED_TIME BETWEEN  '2015-05-18 18:49:52' AND '2015-05-18 18:49:53'
AND AMOUNT>0
AND END_TIME > CURRENT_TIMESTAMP WITH UR

两句加粗效果一样的。

2015-05-26

writed by page_qiu