Formats & Encoding

Data types

- Text
- Date/Time
- Number and Currency
- Yes/No

Text data types

All text data is encoded in UTF-8. The binary content is not concerned.

Date/Time data type

Date is required and Time is Optional, see example below.

Date is required: YYYY-MM-DD

Time is optional and can be declared in several different ways, for example:

Without time zone:
2020-05-30T09:00:00
2020-05-30T09:30:10.5

With time zone:

UTC
2020-05-30T09:30:10Z
2020-05-30T09:30:10.5Z

Offset from UTC
2020-05-30T09:30:10-06:00
2020-05-30T09:30:10+06:00
2020-05-30T09:30:10.5-06:00
2020-05-30T09:30:10.5+06:00

There are two different Date/Time formats:

date-time with the pattern

YYYY-MM-DDThh:mm:ss±hh:mm

For this format, please note that:

The offset +00:00 can be replaced with Z (the zero UTC offset)

date-time-without-timezone with the pattern

YYYY-MM-DDThh:mm:ss

It represents a date without the timezone notion

The following table shows the predefined Format for Date/Time.

Format	Description
YYYY	refers to a four-digit year
MM	refers to a two-digit month of the year, 01 through 12
DD	refers to a two-digit day of that month, 01 through 31
T	is a delimiter between date and time
hh	refers to a two-digit hour, 00 through 23
mm	refers to a two-digit minute, 00 through 59
ss	refers to a two-digit second, 00 through 59
±hh:mm	refers to an offset from UTC

Number and Currency data types

The following table shows the predefined Format for numbers.

Format	Description
General Number
Currency
Euro	Use the euro symbol (Euro symbol)
Fixed	Display at least one digit
Standard
Percent	Multiply the value by 100 and append a percent sign (%)
Scientific	Use standard scientific notation

Yes/No data type

You can set the Format to Yes/No, True/False, or On/Off.