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.