MCQs > IT & Programming > Oracle SQL 9i > Which of the following SELECT statements should be used to extract the year from the system date to display it in the format '2001'?

Oracle SQL 9i MCQs

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

Answer

Correct Answer: SELECT TO_CHAR(SYSDATE, 'yyyy') FROM dual;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Oracle SQL 9i Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it