The format of date and time fields
The format of a date field can have various characteristics, including:
Order of the day, month, and year
Delimiters between day, month, and year
Representation of fully-written-out dates
Type of calendar (Gregorian or Julian)
Abbreviated and full weekday names
Abbreviated and full month names
The format of a time field can have various characteristics, including:
The hour format (for example, 12-hour or 24-hour format)
The representation of minutes and seconds
The locale-specific indicator for AM/PM
If you use the multi-locale feature, you should not use date formats containing 3-letter months (MMM), %b (abbreviated month name), or %B (full month name). Instead, you should use a delimited or fixed format with a numeric value for the month. For more details about date formats, see
Date and time formats
. For more details about the multi-locale feature, see
About the multi-locale feature
.
Date and time formats can appear in SQL statements as well as in the data returned by the database (called a resultset). Some database clients support or require different formats between SQL statements (output) and resultsets (input). The Configuration page for
Campaign
includes a parameter (
DateFormat
,
DateOutputFormatString
,
DateTimeFormat
, and
DateTimeOutputFormatString
) for each of the different formats.
Copyright IBM Corporation 2015. All Rights Reserved.