Documentation: Standard Datatypes
Standard datatypes are used for formatting and sorting of elementary
datatypes often used in websites and web-apps.
Formatting can be localized by setting a "locale" (see examples for
localization in the documentation for xw-browse).
Arbitrary sequence of characters without special formatting; values are sorted
Values are expected to be in JDBC-Date-Format ("YYYY-MM-DD").
Formatting can be controlled by localization.
Date and time; values are expected to start with JDBC-Datetime-Format
("YYYY-MM-DD HH:MM:SS"). Formatting can be controlled by localization.
As "datetime", but values are formatted without seconds.
Number of type integer; formatting can be controlled by localization.
Floating-point number; formatting can be controlled by localization.
Amount of money with 2 fractional digits; formatting can be controlled by localization.
Formatting of boolean values ("true" / "false"), can be controlled by localization.
Because boolean values are often likely to be formatted graphically (e.g. with a
check mark), there is a possibility to replace globally the formatting function
xw.formatBool for boolean values (see demo for xw-browse). Also see documentation for property "formatter" in Initialization-Object of xw-browse and function xw.select() in library xw.js ).