The YEAR function

The following query retrieves rows where the call_dtime is earlier than the beginning of the current year.

Figure 1. Query

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

Figure 2. Query result

customer_num call_code call_year res_year 

         116 I              1997     1997
         116 I              1997     1997