Data Types
==========

AMSelect query expressions use the following scalar data types.

.. list-table::
   :header-rows: 1
   :widths: 18 52 30

   * - Name
     - Description
     - Example
   * - ``bool``, ``boolean``
     - A Boolean value, either ``TRUE`` or ``FALSE``.
     - ``FALSE``
   * - ``int``, ``integer``
     - An 8-byte signed integer in the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
     - ``12345``
   * - ``string``
     - A UTF-8-encoded variable-length string.
     - ``'abc'``
   * - ``float``
     - An 8-byte floating point number.
     - ``CAST(0.456 AS FLOAT)``
   * - ``decimal``, ``numeric``
     - A base-10 number with precision and scale.
     - ``123.456``
   * - ``timestamp``
     - Timestamps represent a specific moment in time and always include a local offset.
     - ``CAST('2007-04-05T14:30Z' AS TIMESTAMP)``

Literals
--------

String literals are enclosed in single quotes.

Numeric literals without a decimal point are integers.

Numeric literals with a decimal point are decimals.

``TRUE`` and ``FALSE`` are Boolean literals.

``NULL`` represents a missing SQL value.