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

Question

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-

• A
  6% (3)
• B
  4% (2)
• C
  13% (7)
• D
  77% (40)

No community discussion yet for this question.