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