Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

YEAR

SQL>  SELECT TO_CHAR(SYSDATE, 'Year')   2  FROM dual; TO_CHAR(SYSDATE,'YEAR') ------------------------------------------ Two Thousand Seven SQL>