xGT Data Types
The BOOLEAN data type supports the storage of two values : TRUE or FALSE. Use the case insensitve keywords TRUE or FALSE or the integer values 1 or 0 to assign a BOOLEAN. If you attempt to assign any other value an error will occur.
The INTEGER data type accepts numeric values. It stores any value between the range of 2^-63 and 2^63 - 1. Attempting to assign values outside this range causes an error. Attempting to assign any character other than numeric digits will result in an error.
The FLOAT data type accepts decimal values. It stores single-precision floating-point values with up to seven decimal digits of precision. Attempting to assign values with greater precision will result in an error. The case insensitive NaN is also an acceptable value. Any other non decimal characters will result in an error.
The DATE data type represents a date composed of a day, month, and year. The expected format for a DATE is YYYY-MM-DD. I.e. a valid DATE would be 2018-12-20. Assigning a DATETIME in the form of YYYY-MM-DDTHH:MM:SS will result in the DATETIME being downcast and losing the precision of the time fields. Attempting to assign any other type will result in an error.
The TIME data type represents a time composed of an hour, minute, second, and (optionally) microsecond. The expected format for a TIME is HH:MM:SS. I.e. a valid TIME would be 06:10:50. Optionally, microseconds can be included where the expected format is HH:MM:SS.μμμμμμ. I.e. a valid TIME with microseconds would be 06:10:50.000006. Attempting to assign any other type will result in an error.
The DATETIME data type represents a combination of a date and time composed of a day, month, year, hour, minute, and second. The expected format for a DATETIME is YYYY-MM-DDTHH:MM:SS. I.e. a valid DATETIME would be 2018-12-20T06:10:50. Assigning a DATE to a DATETIME will result in the DATE being "promoted" to a DATETIME with zeroes for the time fields. Attempting to assign any other type will result in an error.
The IPADDRESS data type represents a IPv4 IP address. The expected format of an IPADDRESS is xxx.xxx.xxx.xxx. I.e. a valid IPADDRESS would be 172.16.254.1. Assigning an IPv6 IP address or any other type will result in an error.
The STRING data type represents a string of unicode characters.