Quick Search:
 
 Oracle PL/SQL: Date Functions: TO_NCHAR Jump to:  
Category: >> Oracle PL/SQL >> Date Functions: TO_NCHAR  

<< lastnext >>

Snippet Name: Date Functions: TO_NCHAR

Description: Converts a DATE or TIMESTAMP from the database character set to the National Character Set specified.

Also see:
» BR2NL Function: Opposite of NL2BR
» A JavaScript implementation of the fam...
» Call a PHP function when clicking on a...
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» Recursive fopen() function
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» PACKAGES: one function
» INDEXES: Function-Based Index
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» Alternate Title Case function
» SELECT: Using Functions
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

TO_NCHAR(<date_string | interval>, <format mask>, <NLS_PARAMETER>)
 
conn oe/oe
 
SELECT TO_NCHAR(order_date)
FROM orders
WHERE order_status > 9;
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org