Open Lake has a set of built-in data types, described below.
This type captures boolean values
INTEGERwill upcast to
BIGINTin Upsolver Open Lake. The name
INTis also available for this type.
A 64-bit signed two’s complement integer with a minimum value of
-2^63and a maximum value of
2^63 - 1.
A double is a 64-bit inexact, variable-precision implementing the IEEE Standard 754 for Binary Floating-Point Arithmetic.
Variable length character data with an optional maximum length.
Example type definitions:
Calendar date (year, month, day).
Instant in time that includes the date and time of day without a time zone. Values of this type are parsed and rendered in the session time zone.
TIMESTAMP '2001-08-22 03:04:05.321'