数据库中日期的比较是很常见的,下面来介绍一种DB2中关于日期比较的sql写法:
SELECT ID FROM
(
SELECT ID,TIMESTAMP(TRIM(CHAR(CTIME))) + 1 DAYS RESULTTIME FROM TABLE) T WHERE T.RESULTTIME < ( SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1)
(
SELECT ID,TIMESTAMP(TRIM(CHAR(CTIME))) + 1 DAYS RESULTTIME FROM TABLE) T WHERE T.RESULTTIME < ( SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1)
SELECT ID,PATH FROM TABLE WHERE TIMESTAMP(TRIM(CHAR(CTIME))) + 1 DAYS < ( SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1);