IBM® Informix® Client Software Development Kit, Version 4.10

ANSI SQL standards for DATETIME and INTERVAL values

The ANSI SQL standards specify qualifiers and formats for character representations of DATETIME and INTERVAL values. The standard qualifier for a DATETIME value is YEAR TO SECOND, and the standard format is as follows:
YYYY-MM-DD HH:MM:SS
The standards for an INTERVAL value specify the following two classes of intervals:
  • The YEAR TO MONTH class has the format: YYYY-MM

    A subset of this format is also valid: for example, just a month interval.

  • The DAY TO FRACTION class has the format: DD HH:MM:SS.F

    Any subset of contiguous fields is also valid: for example, MINUTE TO FRACTION.


Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.