When you set up your
users, you reference a display profile. A user's display
profile controls how dates, times, and numbers displayed.
Choose
to maintain
display profiles.
Description of Page
Enter a unique
Display Profile ID and
Description to identify the profile.
Enter a
Date Format. This affects how users view
dates and how entered dates are parsed. This is a "free format"
field with some rules.
-
dd or
d is interpreted as the day of the
month. The
d option suppresses a leading 0.
-
MM or
M is interpreted as the month number.
The
M option suppresses a leading 0.
-
yyyy,
yy, or
y is interpreted as the year. The year
can be 4 or 2 digits. The
y option allows entry in either 2 or
4-digit form and is displayed in 2-digit form.
Note: For centuries, the default pivot for
2-digit years is
80. Entry of a 2-digit year greater than
or equal to
80 results in the year being interpreted
as 19xx. Entry of a 2-digit year less than
80 results in the year being interpreted
as 20xx.
-
tttt is interpreted as a year entered
and displayed in Taiwanese format where 1911 is considered
year 0000. Note that the year is still stored in the database
in Roman format. For example, if a date in the database is
01-01-2005, it is displayed as 01-01-0094. If a user enters
the date 02-02-0095, it is stored in the database as
02-02-2006.
- Other characters are displayed as entered. Typically,
these other characters should be separators, such as "-",
".", or "/". Separators are optional; a blank space cannot be
use.
Here are some examples of date formats.
|
Format
|
Displayed / entered as
|
|
MM-dd-yyyy
|
04-09-2001 |
|
d/M/yyyy
|
9/4/2001 |
|
yy.MM.dd
|
01.04.09
|
|
MM-dd-y
|
04-09-01 - in this case you could also enter the
date as 04-09-2001 |
Enter a
Time Format. This is a "free format"
display with some rules.
-
hh or
h is interpreted as the hour,
1-12;
KK or
K is interpreted as the hour,
0-11;
HH or
H is interpreted as the hour,
0-23;
kk or
k is interpreted as the hour, 1-24. The
h,
K,
H, and
k options suppress a leading 0.
-
mm or
m is interpreted as the minutes. The
m option suppresses a leading 0.
-
ss or
s is interpreted as the seconds. The
s option suppresses a leading 0.
-
a is interpreted to mean display
am or
pm (only needed when the hour is
entered in
hh,
h,
KK or
K formats). If an
am or
pm is not entered, it defaults to
am.
Here are some examples of time formats.
|
Format
|
Displayed / entered as
|
| hh:mma |
09:34PM (can be entered as 09:34p) |
| hh:mm:ss |
21:34:00 |
| h:m:s |
9:34:0 |
There are several options for displaying Numbers. Select the
character you use as the Decimal Symbol (" ." or "
,"), the symbol that separates the
integer and decimal parts of a number. Select the character you
use as the
Group Symbol ("
,", " .",
None or
Space), i.e., the symbol used to
separate 1000s. Select an option for the
Negative Format, which dictates how
negative values are displayed:
‑9.9, (9.9), or 9.9-.
Currency values can have a different
Negative Format from other
numbers: -s9.9, (s9.9), or s9.9-, where the "s"
represents the currency symbol.
Where Used
Follow this link to open the data dictionary where you can
view the tables that reference CI_DISP_PROF.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.