Primitive Data Type Representations
All primitive data types used by QAD applications (character or string, integer, decimal, date, time, Boolean or logical) are represented in QDocs using the data type standards specified for XML schemas. The most interesting cases in this regard are dates, times, integers, and decimals.• Dates are represented as YYYY-MM-DD (for example, 2003-04-22).
• Times are represented as HH:MM:SS+HH:MM (for example, 23:20:06+07:00 or 23:20:06-02:00), where the expression +HH:MM is the number of hours and minutes ahead or behind Universal Time (also called Greenwich Mean Time).
• The type dateTime is an XML-schema-defined type that is a combination of the date and time types as specified by ISO 8601. Its representation is the concatenated values of date and time separated by an upper-case T, in the format YYYY-MM-DDTHH:MM:SS+HH:MM. For example, 2003-04-22T23:20:06-08:00 would denote 11:20 pm Pacific Standard Time on April 22, 2003.
• Integers are represented normally, with an optional + or – sign preceding the digits.
• Decimals are represented with the period (.) as the decimal point and optionally the comma (,) as the thousands separator.
The application is responsible for managing the display formats used in different geographies; for example:• Reversing the usage of the period and comma for quantities
• Modifying the sequence of the day-month-year components of dates