Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

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;

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
49 views



Related Hot Questions



Government Jobs Opening


...