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

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

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

All the above.