Data Type Format settings

The data type characterizes the data in a dataset column. The format defined for a data type allows a column to be typed when it is read into a dataset.

These options are displayed when you click the Edit data type format button on the Data Settings page while you configure a dataset.

Locale option

The Locale option must be set before you can configure date, time, and numeric data format options. The locale recognizes culture-specific date, time, date-time, and numeric formats in the data.

Locale
Specifies a language and country pair that defines a supported locale.

Set Date and Time Format options

The date and time format options characterize date, time, and date-time fields that are read into a dataset. Sample data is shown next to the each selection. Delimiters between months, days, years, hours, and minutes are indicated by the asterisk (*) wildcard. This matches any delimiting character within a format. For example, mm*dd*yy format matches both 02/24/2022 and 02-24-2022 in a date field.

The Locale setting determines formats available for date, time, and date-time fields. For example, in the English (United States) locale, the month precedes the day (02/24/2022). In many other locales the day precedes the month (24/02/2022).

Date
Specifies the format for data displayed in date fields.
Time
Specifies the format for data displayed in time fields.
DateTime
Specifies the format for data displayed in date-time fields.

Set Numeric Format options

The numeric format options characterize whole number (such as integer) and decimal number (such as fields that are read into a dataset.

The Locale setting determine options available for numeric format fields. For example, in the English-United States locale, the thousands separator is a comma (,) and the decimal separator is a period (.). In many other locales, the thousands separator is a period (.) and the decimal separator is a comma (,).

Whole numbers
Specifies the format for data displayed in whole number fields (long or integer data types).
Decimal numbers
Specifies the format for data displayed in decimal number fields (float data type).