YEAR 函数

图: 程序

SELECT customer_num, call_code, 
          YEAR (call_dtime) call_year,
          YEAR (res_dtime) res_year
          FROM cust_calls
          WHERE YEAR (call_dtime) < YEAR (TODAY);

customer_num call_code call_year res_year 
              
              116 I              1997     1997
              116 I              1997     1997