Month abbreviations consist of the first three characters of the month’s name. Months with four-character names, such as June, are not abbreviated.
Here are some examples, using December 18, 2010:
Example |
Description |
Result |
1 |
Format type 1 |
12/18/10 |
1- |
Format type 1 with dashes (-) as the separator characters |
12-18-10 |
1/2 |
Format type 1 with backslashes (/) as the separator characters and a two-digit year |
12/18/10 |
14 |
Format type 1 with a four-digit year (no separator specified but the format type includes separators so the default separator (/) will be used |
12/18/10 |
B4 |
Format type B with a four-digit year (no separator specified and the format type does not include separators, so none will be included) |
12182010 |
4@CAD |
Format type 4, with French Canadian as the locality. If you use "4@CAD" in a DAL function, the system returns the French Canadian translation of date format type 4 (Month D, YYYY with month spelled out). If you specify a locale, it must be the last component of the date format |
décembre 18, 2010 |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.