TO_CHAR

TO_CHAR(expr[,fmt])

Returns the character representation of expr based on the fmt string or the default for expr's data type. If expr is already a character string, expr is not converted.

If expr is a numeric value, fmt can be:

% Percent sign at right of number
$ Dollar sign at left of number
B Display zero as blank
0 Display leading zeros
9 A digit position
other     Delimiting character (not leading)

The default mask is as many nines (9s) as required for the number's precision and scale.

If expr is a date value, fmt can be:

YYYY Four-digit year
YY Two-digit year
RR Two-digit year in another century
MM Two-digit month of year (01 to 12)
MON Three-character month (all uppercase)
mon Three-character month (all lowercase)
Mon Three-character month (initial cap)
MONTH     Fully named month (all uppercase)
month Fully named month (all lowercase)
Month Fully named month (initial cap)
DDD Three-digit day of year (001 to 356)
DD Two-digit day of month (01 to 31)
D Single-digit day of week (1 to 7)
DY Three-character day (all upper case)
dy Three-character day (all lowercase)
Dy Three-character day (initial cap)
DAY Fully named day (all uppercase)
day Fully named day (all lowercase)
Day Fully named day (initial cap)
HH12 Two-digit hour (00 to 11)
HH,HH24 Two-digit hour (00 to 23)
MI Two-digit minutes (00 to 59)
SS Two-digit seconds (00 to 59)
SSSSS Seconds past midnight (0000 to 86399)
J Julian day
Q Single-digit quarter of year (0 to 4)
W Single-digit week of month (1 to 4); the week begins on Sunday
WW Two-digit week of year (01 to 52)
other Delimiting character

To add character extensions to the values that represent counting, such as ST, ND, RD, or TH, simply add th to any uppercase digit mask. The function correctly interprets the extension based on the last digit and the case based on the mask's case.

Put embedding characters that are valid masks inside double quotes (" ").

The default mask is DD-MON-YY.