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).