Multiple choice technology databases

Which of the following tasks can be performed by using the TO_CHAR function?

  1. Convert '10'to 10

  2. Convert 'TEN' to 10

  3. Convert 10 to '10'

  4. Convert a character expression to a date
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

TO_CHAR converts an input value (such as a number or date) into a character string format, meaning it converts numeric 10 to character '10'. TO_NUMBER converts numeric strings like '10' to 10. TO_DATE is used to convert character expressions into date datatypes.

Keep practicing — related questions