Date Formatting Symbols
The following table describes the date format symbols that you can use when formatting dates in
Oracle Fusion Cloud Enterprise Data Management, such as
when defining extract options or using the toDate
or
format
methods in expressions. Note that the fields are
case-sensitive.
Symbol | Date or Time Component | Examples |
---|---|---|
G |
Era designator | AD |
y |
Year | 1996; 96 |
Y |
Week year | 2009; 09 |
M |
Month in year | July; July; 07 |
w |
Week in year | 27 |
W |
Week in month | 2 |
D |
Day in year | 10 |
d |
Day in month | 2 |
E |
Day name in week | Tuesday; Tue |
u |
Day number of week (1 = Monday, 7 = Sunday) | 1 |