![]() |
|
The literal DATETIME segment specifies a literal DATETIME value. Use the literal DATETIME segment whenever you see a reference to a literal DATETIME in a syntax diagram.
You must specify both a numeric date and a DATETIME field qualifier for this date in the Literal DATETIME segment. The DATETIME field qualifier must correspond to the numeric date you specify. For example, if you specify a numeric date that includes a year as the largest unit and a minute as the smallest unit, you must specify YEAR TO MINUTE as the DATETIME field qualifier.
The following example shows a literal DATETIME value used with the EXTEND function:
For discussions of the DATETIME data type and the DBCENTURY environment variable, see the Informix Guide to SQL: Reference.
For a discussion of customizing DATETIME values for a locale, see the Informix Guide to GLS Functionality.