Multiple choice technology databases

For which action can you use the TO_DATE function?

  1. Convert any date literal to a date.

  2. Convert any numeric literal to a date.

  3. Convert any character literal to a date.

  4. Convert any date literal to a character literal

  5. Format '10-JAN-99' to 'January 10 1999'.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The TO_DATE function in SQL is used to convert a character string (character literal) representing a date into an actual DATE data type, using a specified format mask. It does not convert date literals to dates or format dates into other character strings.

Keep practicing — related questions