Multiple choice

What is the output of the following? substr (hiredate, - 2, 2) Given that hiredate is 01 Feb 13.

  1. 1

  2. 01

  3. 13

  4. 31

  5. None of these

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

substr function extracts part of the date data type as per the parameters given in it. -2 indicates that the counting will starts from Right side and 2 character will be selected. Hence 13.