The format of date and time fields
This section describes considerations relating to date and time formats.
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
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 Unica Campaign includes a parameter (DateFormat, DateOutputFormatString, DateTimeFormat, and DateTimeOutputFormatString) for each of the different formats.