Literals

A literal or constant is a fixed data value, composed of a sequence of characters or a numeric constant. Amazon Redshift supports several types of literals, including:

• Numeric literals for integer, decimal, and floating-point numbers. For more information, see Integer and floating-point literals.

• Character literals, also referred to as strings, character strings, or character constants

• Datetime and interval literals, used with datetime data types. For more information, see Date, time, and timestamp literals and Interval data types and literals.