Oracle 两周前检查到期

SQL> create table t (
  2    id int,
  3    expiry date);

Table created.

SQL>
SQL> insert into t values (1,sysdate-10);

1 row created.

SQL> insert into t values (2,sysdate+1/2);

1 row created.

SQL> insert into t values (3,sysdate+9);

1 row created.

SQL> insert into t values (4,sysdate+16);

1 row created.

SQL> insert into t values (5,sysdate+17);

1 row created.

SQL> insert into t values (6,sysdate+25);

1 row created.

SQL>
SQL> select * from t;

        ID EXPIRY
---------- ---------
         1 10-MAR-18
         2 21-MAR-18
         3 29-MAR-18
         4 05-APR-18
         5 06-APR-18
         6 14-APR-18

6 rows selected.

SQL>
SQL> select id,
  2         'Expires in '||(expiry-sysdate)||' days'
  3  from   t
  4  where  expiry between sysdate and sysdate + 14;

        ID 'EXPIRESIN'||(EXPIRY-SYSDATE)||'DAYS'
---------- ----------------------------------------------
         2 Expires in .5 days
         3 Expires in 9 days
复制