Syntax

Purpose

TO_NCHAR (number) converts a number to a string in the NVARCHAR2 character set. The optional fmt and 'nlsparam' corresponding to n can be of DATE, TIMESTAMP, TIMESTAMPWITHTIMEZONE, TIMESTAMPWITHLOCALTIMEZONE, INTERVALMONTHTOYEAR, or INTERVALDAYTOSECOND datatype.