TO_NCHAR (datetime)

Syntax

to_nchar_date::=

Text description of to_nchar_date

Purpose

The TO_NCHAR (datetime) function converts a character string of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL MONTH TO YEAR, or INTERVAL DAY TO SECOND datatype from the database character set to the national character set.

Example

SELECT TO_NCHAR(ORDER_DATE) FROM ORDERS 
WHERE ORDER_STATUS > 9; 

TO_NCHAR(ORDER_DATE) 
---------------------------- 
14-SEP-99 08.53.40.223345 AM 
13-SEP-99 09.19.00.654279 AM 
27-JUN-00 08.53.32.335522 PM 
26-JUN-00 09.19.43.190089 PM 
06-DEC-99 01.22.34.225609 PM