Data Types

In the Log Parser SQL-Like language, each field-expression has a related data type, which is an attribute that specifies the type of data that the field-expression can hold.
Log Parser supplies a set of system data types that define all of the types of data that can be used with Log Parser. The set of system-supplied data types is:

INTEGER: integer numeric data;
REAL: floating precision numeric data;
STRING: variable length UNICODE character string data;
TIMESTAMP: date and time data;
NULL: unknown or unavailable data.