Organizational Research By

Surprising Reserch Topic

Experts Most Trusted 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



Walkin Jobs Opening



Government Jobs Opening


...