How do I get the current year using SQL on Oracle?

Question

I need to add the current year as a variable in an SQL statement, how can I retrieve the current year using SQL?

i.e.

   BETWEEN      TO_DATE('01/01/**currentYear** 00:00:00', 'DD/MM/YYYY HH24:MI:SS')     AND     TO_DATE('31/12/**currentYear** 23:59:59', 'DD/MM/YYYY HH24:MI:SS') 

Answer 1

Using to_char:

select to_char(sysdate, 'YYYY') from dual; 

In your example you can use something like:

BETWEEN trunc(sysdate, 'YEAR')      AND add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60; 

The comparison values are exactly what you request:

select trunc(sysdate, 'YEAR') begin_year      , add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60 last_second_year from dual;  BEGIN_YEAR  LAST_SECOND_YEAR ----------- ---------------- 01/01/2009  31/12/2009