SQL Data Types Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. SQL Data Types
  4. YEAR
SQL>  SELECT TO_CHAR(SYSDATE, 'Year')
  2  FROM dual;
TO_CHAR(SYSDATE,'YEAR')
------------------------------------------
Two Thousand Seven
SQL>