Question:Which of the following SELECT statements should be used to extract the year from the system date to display it in the format "2001"? 

A SELECT TO_CHAR(SYSDATE, 'yyyy') FROM dual; 
B SELECT TO_DATE(SYSDATE, 'yyyy') FROM dual; 
C SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual; 
D SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual; 
E SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual; 

+ Answer
A 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description