PL/SQL To_char

The TO_CHAR function converts a number or date to a varchar2.

To_char syntax

TO_CHAR( value, [ format_mask ], [ nls_param ] )

To_char example

 
select to_char(2015.82, '9999.99') from dual;	

Result:  2015.82


select to_char(2015.82, '9999.999') from dual;	

Result:  2015.820


select to_char(2015.82, '$9,999.00') from dual;	

Result:  $2,015.82


select to_char(sysdate, 'yyyy/mm/dd') from dual;	

Result: 2014/12/26


select to_char(sysdate, 'MON DDth, YYYY') from dual;

Result: DEC 26TH, 2014


select to_char(sysdate, 'yyyy') from dual;

Result: 2014

To_char example

STUDENT_IDFIRST_NAMELAST_NAMECITY
1DanielSCOTTNew York
2AnthonySIMMONSChicago
3SophiaTHOMPSONLos Angeles
select s.STUDENT_ID, s.FIRST_NAME, s.LAST_NAME, s.CITY 
from STUDENTS s 
where TO_CHAR(s.STUDENT_ID)='2';
STUDENT_IDFIRST_NAMELAST_NAMECITY
2AnthonySIMMONSChicago