Product Documentation

SQL Reference Guide

Previous Topic

Next Topic


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