2.4 Literals

Literals are used to directly represent data. Examples of standard types of literals are:

  1. integer        - 0, -34, 45, 0X080000000;
  2. fixed-point    - 0.0, -3.14
  3. floating-point - 3.23e-23;
  4. string         - 'text', 'don''t!';
  5. binary string  - x'48656C6C6F20776F726C64'
  6. date           - DATE '2018-01-19';
  7. time           - TIME '15:12:56';
  8. timestamp      - TIMESTAMP '2018-01-19 13:32:02';
  9. boolean        - true, false, unknown
  10. null state     - null

Details about handling the literals for each data type are discussed in the next chapter, Data Types and Subtypes.