SQL Reference Guide

Literals

Literals are a type of expression that specify a constant value (they are also called constants). You can specify literals wherever FairCom DB SQL syntax allows expressions. Some FairCom DB SQL constructs allow literals but prohibit other forms of expressions.

There are three types of literals:

• Numeric
• Character string
• Date-time

The following sections discuss each type of literal.

In This Section Numeric Literals Character String Literals Date-Time Literals Date Literals Time Literals Timestamp Literals