IBM
C2090-320 · Question #17
C2090-320 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-320 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
Which of the following SELECT statements returns a different data value than the other SQL statements?
Options
- ASELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
- BSELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
- CSELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENT TIMESTAMP(10)),6,2),'0'),11,'') FROM
- DSELECT TIMESTAMPDIFF(64, CHAR(CURRENT TIMESTAMP ?TIMESTAMP(`2016-01-01-
Unlock C2090-320 to see the answer
You've previewed enough free C2090-320 questions. Unlock C2090-320 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.