Which of the following shows the correct result of the nested substring functions: substring-before(substring-after("2017-10-05", "-") , "-") ?
A) "-"
B) "05"
C) "2017"
D) "10"

Question

Quizplus · Accepted Answer

The nested substring functions first extract the substring after the first occurrence of "-" resulting in "10-05", then extract the substring before the second occurrence of "-" resulting in "10". Therefore, the correct result is "10".

Which of the Following Shows the Correct Result of the Nested