© Copyright 2014, Oracle and/or its affiliates. If you specify a locale, it must be the last component of the date format If you use in a DAL function, the system returns the French Canadian translation of date format type 4 (Month D, YYYY with month spelled out). Here are some examples, using December 18, 2010:įormat type 1 with dashes (-) as the separator charactersįormat type 1 with backslashes (/) as the separator characters and a two-digit yearįormat type 1 with a four-digit year (no separator specified but the format type includes separators so the default separator (/) will be usedįormat type B with a four-digit year (no separator specified and the format type does not include separators, so none will be type 4, with French Canadian as the locality. * This format defaults to a two-digit year, but can be overridden to have four digits. Valid dates may differ depending on the type of machine (PC or host) and the type of CPU chip. Week where Monday is the first day of the week (01 to 53). ) Week where Sunday is the first day of the week (01 to 53). This format defaults to a two-digit year, but can be overridden to have four digits.Įight-character hexadecimal representation of the system date. Can be one or a combination of the following values: Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd.
Year, Month abbreviation, Day with leading zeros Month abbreviation, Day with leading zeros, Yearĭay with leading zeros, Month abbreviation, Year Year-Day of Year (counting consecutively from January 1-often called the Julian date format) (2009/48) Year-Month abbreviation-Day with leading zeros (2009Feb17)ĭay of year (counting consecutively from January 1)-Year (48/2009) Month abbreviation-Day-Year with leading zeros (Feb172009)ĭay-Month abbreviation-Year with leading zeros (17Feb2009) Year-Month-Day with no separators (20090217) Month-Day-Year with no separators (02172009)ĭay-Month-Year with no separators (17022009) Year-Month-Day with spaces instead of leading zeros (2009/ 2/17)
Month-Day-Year with spaces instead of leading zerosĭay-Month-Year with spaces instead of leading zeros Month name-Day-Year with no leading zeros ISO: Date and time format of the International.
EUR: IBM standard for European date and time format. The formats supported are: DEF: Date and time format associated with the territory code. Months with four-character names, such as June, are not abbreviated. If you want to change the format, you can bind the collection of DB2 utility packages to use a different date format. Month abbreviations consist of the first three characters of the month’s name. You are here: Function Reference > Date Functions > Date Formats > Date Format Types Date Format Types