Advanced Search

Oracle TO_CHAR Examples

/ Published in: SQL
Save to your folder(s)
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT TO_CHAR(12345.67, '99999.9') FROM DUAL;
  2.  
  3. SELECT TO_CHAR(12345, '00000000') FROM DUAL;
  4.  
  5. SELECT TO_CHAR(SYSDATE, 'YYYY_MM_DD') FROM DUAL;
  6.  
  7. SELECT TO_CHAR(SYSDATE, 'Month') FROM DUAL;

URL: http://www.databasestar.com/oracle-to_char/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.