Oracle PL/SQL - TO_CHAR function

TO_CHAR Function : 

Syntax : TO_CHAR (input_value, fmt_mask, nls_language); 
  • input_value can be either a string,number or a interval of datetime.
  • Return type is VARCHAR2
  • fmt_mask is the format type to which the input value is converted. This parameter is optional.
  • nls_language determines the language in which the month,day and other abbreviated strings are returned. This parameter is optional.

Example 1:

SELECT TO_CHAR(SYSDATE, 'yyyy/mm/dd') FROM DUAL;

RESULT
-----------
2015/03/09

Example 2:

SELECT TO_CHAR(SYSADTE, 'Month DD, YYYY') FROM DUAL;

RESULT
-----------
March 09, 2015
ParameterExplanation
YYYY 4-digit year
YEARYear, spelled out
YYY YY YLast 3, 2, or 1 digit(s) of year.
IYY IY ILast 3, 2, or 1 digit(s) of ISO year.
IYYY4-digit year based on the ISO standard
QQuarter of year (1, 2, 3, 4; JAN-MAR = 1).
MMMonth (01-12; JAN = 01).
MONAbbreviated name of month.
MONTHName of month, padded with blanks to length of 9 characters.
RMRoman numeral month (I-XII; JAN = I).
WWWeek of year (1-53) where week 1 starts on the first day of the year and continues to the seventh
day of the year.
WWeek of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
IWWeek of year (1-52 or 1-53) based on the ISO standard.
DDay of week (1-7).
DAYName of day.
DDDay of month (1-31).
DDDDay of year (1-366).
DYAbbreviated name of day.
JJulian day; the number of days since January 1, 4712 BC. specified with J must be integers
HHHour of day (1-12).
HH12Hour of day (1-12).
HH24Hour of day (0-23).
MIMinute (0-59).
SSSecond (0-59).
FF Fractional seconds.
 SSSSSSeconds past midnight (0-86399)