sql - 选择具有过期日期的产品行

Question

我有一个表格如下:

PRODUCT(P_CODE, DESCRIPTION, PRODUCTION_DATE)

过期产品是指生产超过1年的产品。如何列出所有已过期的产品及其过期日期？

Answer 1

create table PRODUCT(P_CODE number, DESCRIPTION varchar2(200), PRODUCTION_DATE date);

insert into product values(1,'XXX',to_date('12-03-2013','dd-mm-yyyy'));

insert into product values(2,'YYY',to_date('13-03-2012','dd-mm-yyyy'));

insert into product values(3,'ZZZ',to_date('12-08-2012','dd-mm-yyyy'));

insert into product values(4,'AAA',to_date('16-08-2013','dd-mm-yyyy'));   

select p_code
      ,description
      ,production_date
      ,add_months(production_date,12) expire_date  
 from product
where production_date<add_months(sysdate,-12)