You can enter dates in a variety of formats. The date format has three possible components or characters. The first character specifies the order of the date. The second character specifies the type of separator character for the date. The third character specifies the length of the year.
The first character in the date format indicates the order of the date and whether the month should be numeric or alphabetic. The first character must be a digit from 1 to 9 or an alphabetic character. The default order is format 1. The following table lists your options:
|
Format |
Date order |
Description |
|
1 |
MM/DD/YY |
Month-Day-Year with leading zeros (02/17/2009) |
|
2 |
DD/MM/YY |
Day-Month-Year with leading zeros 17/02/2009 |
|
3 |
YY/MM/DD |
Year-Month-Day with leading zeros 2009/02/17 |
|
4 |
Month D, Yr |
Month name-Day-Year without leading zeros (February 17, 2009) |
|
5 |
bM/bD/YY |
Month-Day-Year with leading zeros replaced with spaces |
|
6 |
bD/bM/YY |
Day-Month-Year with leading zeros replaced with spaces |
|
7 |
YY/bM/bD |
Year-Month-Day with leading zeros replaced with spaces |
|
8 |
M/D/YY |
Month-Day-Year with leading zeros suppressed |
|
9 |
D/M/YY |
Day-Month-Year with leading zeros suppressed |
|
A |
YY/M/D |
Year-Month-Day with leading zeros suppressed |
|
B |
MMDDYY |
Month-Day-Year with no separators (02172009) |
|
C |
DDMMYY |
Day-Month-Year with no separators (17022009) |
|
D |
YYMMDD |
Year-Month-Day with no separators (20090217) |
|
E |
MonDDYY |
Month name abbreviated-Day-Year with leading zeros (Feb072009) |
|
F |
DDMonYY |
Day-Month name abbreviated-Year with leading zeros (07Feb2009) |
|
G |
YYMonDD |
Year-Month name abbreviated-Day with leading zeros (2009Feb07) |
|
H |
day/YY |
Day of year (counting consecutively from January 1)-Year (48/2009) |
|
I |
YY/day |
Year-Day of Year (counting consecutively from January 1) (often called the Julian date format) (2009/48) |
|
J |
D Month, Yr |
Day- Month name-Year without leading zeros (7, February 2009) |
|
K |
Yr, Month D |
Year-Month name-Day without leading zeros (2009 January 5) |
|
L |
Mon-DD-YY |
Month name abbreviated-Day-Year with leading zeros (Feb-17-2009) |
|
M |
DD-Mon-YY |
Day-Month name abbreviated-Year with leading zeros (02-Feb-2009) |
|
N |
YY-Mon-DD |
Year-Month name abbreviated-Day with leading zeros (2009-Feb-17) |
|
X |
XXXXXXXX |
An eight-character hexadecimal representation |
The second character in the date format indicates the separator to use in the date. If you omit the separator character, the system includes a forward slash (/). You can choose from these separator characters:
|
Character |
Example |
|
/ |
02/17/2009 |
|
- |
02-17-2009 |
|
. |
02.17.2009 |
|
, |
02,17,2009 |
|
b (blank) |
02 17 2009 |
You specify the separator character by including it as the second character in the date format. For example, if you enter 5-, you specify date format 5 with a dash as a separator character. The date appears as 02-17-2009. If you enter 5b, you specify date format 5 with blanks or spaces as a separator. Your date appears as 02 17 2009.
The third character in the date format specifies the year length. The year must appear as either two or four digits. Enter 2 for a two digit year or 4 for a four digit year.
You can omit the year length character from a date format. If you do not specify the year length, the system uses the length of the original entry. For example, if you enter a date as 10/30/09 and do not specify a length, the system retains 05. If you enter 10/30/2009, the system retains 2009.
If you enter 5-2, you specify date format 5, a dash (-) as a separator character and a two-digit year. Your date appears as _9-11-09. If you enter 5-4, your date appears as _9-11-2009.
© Copyright 2015, Oracle and/or its affiliates. All rights reserved. Legal notices.