Specify a non-null value.

 

Syntax

 

<literal> ::=

 

<unsigned literal> ::=

 

<general literal> ::=

 

 

Usage

 

Literals, commonly perceived as constants, can be used in SQL everywhere a value can be specified. Since literals have a data type, they can only be used in places where data of the particular type is permitted.

 

 


 

Conformance

 

SQL:2003 standard

 

-

-

-

-

-

Core SQL

Feature F421 "National character"

Feature T041 "Basic LOB data type support"

Feature F052 "Intervals and datetime arithmetic"

Feature T031 "BOOLEAN data type"

 


 

Numeric Literals

String Literals

DateTime Literals

Interval Literals

Boolean Literals