DATETIME and INTERVAL functions for C

The following DATETIME and INTERVAL functionality is available only to users of IBM® Informix® ESQL/C. To use these functions, ESQL/C users must manually link their C code to the ESQL/C libraries.

The DATETIME and INTERVAL data types are internally represented with the dtime_t and intrvl_t structures, respectively. Information about these structures can be found in the header file datetime.h, which is included in the ESQL/C product. Include this file in all C source files that use any of the DATETIME and INTERVAL functions.

You must use the following ESQL/C library functions for the datetime and interval data types to perform all operations on those types of values.

Function Name Description
dtaddinv( ) Adds an interval value to a datetime value
dtcurrent( ) Gets the current date and time
dtcvasc( ) Converts an ANSI-compliant character string to a datetime value
dtcvfmtasc( ) Converts a character string with a specified format to a datetime value
dtextend( ) Changes the qualifier of a datetime value
dtsub( ) Subtracts one datetime value from another
dsubinv() Subtracts an interval value from a datetime value
dttoasc( ) Converts a datetime value to an ANSI-compliant character string
dttofmtasc( ) Converts a datetime value to a character string with a specified format
incvasc( ) Converts an ANSI-compliant character string to an interval value
incvfmtasc( ) Converts a character string with a specified format to an interval value
intoasc( ) Converts an interval value to an ANSI-compliant character string
intofmtasc( ) Converts an interval value to a character string with a specified format
invdivdbl( ) Divides an interval value by a numeric value
invdivinv( ) Divides an interval value by another interval value
invextend( ) Extends an interval value to a different interval qualifier
invmuldbl( ) Multiples an interval value by a numeric value

For more information about the individual functions, see IBM Informix ESQL/C Programmer's Manual.


Feedback