IBM Exam C2090-320 Topic 5 Question 31 Discussion

Actual exam question for IBM's C2090-320 exam

Question #: 31
Topic #: 5

Which of the following SELECT statements returns a different data value than the other SQL statements ?

ASELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

BSELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

CSELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0')l11l') FROM SYSIBM.SYSDUMMY1;

DSELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP('2016-01-01-00.00.00'))) FROM SYSIBM.SYSDUMMY1;

Show Suggested Answer

Suggested Answer: A

by Xochitl at May 05, 2022, 05:02 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!