A script-enabled browser is required for this page to function properly.

Format Mask Elements

The following format mask elements allow you to override the default format masks.

Date format mask elements

Character

Returns

D

Digit for the day (1-7)

DY

Name of the day (abbreviated)

DAY

Name of the day (padded with blanks to the length of 9 characters)

WW

Digit for the week, calculated by the algorithm int((day-jan1)/7)

IW

Digit of the ISO week

MON

Name of the month (abbreviated)

MONTH

Name of the month (padded with blanks to the length of 9 characters)

RM

Character for the Roman numeral month

I,IY,IYY,IYYYY

Last one, two, or three digits of the ISO year or the ISO year, respectively

BC,AD,B.C.,A.D.

BC or AD indicator (with or without periods)

AM,PM,A.M.,P.M.

AM or PM indicator (with or without periods)

For more information on ISO and its date format masks, see the Oracle Server SQL Reference.

Number format mask elements

Character

Returns

C

International currency symbol

L

Local currency symbol

D

Decimal separator

G

Group (thousands) separator