Advanced Search

Return to Snippet

Revision: 71030
at December 5, 2016 05:36 by bbrumm
Initial Code 
SELECT TO_CHAR(12345.67, '99999.9') FROM DUAL;

SELECT TO_CHAR(12345, '00000000') FROM DUAL;

SELECT TO_CHAR(SYSDATE, 'YYYY_MM_DD') FROM DUAL;

SELECT TO_CHAR(SYSDATE, 'Month') FROM DUAL;
Initial URL 
http://www.databasestar.com/oracle-to_char/
Initial Description 
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
Initial Title 
Oracle TO_CHAR Examples
Initial Tags 
sql, Oracle
Initial Language 
SQL