Multiple choice technology web technology

Which of the following are true about TO_CHAR?

  1. It converts a datetime datatype to a value of varchar2 datatype.

  2. It can be used to convert character,number or datetime data to Varchar2.

  3. When converting datetime and numberdata,a format(fmt) parameter can be specified to apply regional formatting to a data.

  4. All the above.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

TO_CHAR is a versatile SQL conversion function that transforms datetime, number, or character data into VARCHAR2 format. When converting datetime or number data types, you can specify an optional format parameter to control the output appearance, including regional formatting settings like date separators and decimal symbols. This makes TO_CHAR essential for presenting data in human-readable formats.

Keep practicing — related questions