informix
INFORMIX-ESQL/C Programmer's Manual
Working with Time Data Types

DATETIME and INTERVAL Library 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. The following C functions are available in ESQL/C to handle datetime and interval host variables.

Function Name Description Page Reference
dtaddinv() Adds an interval value to a datetime value B-63
dtcurrent() Gets the current date and time B-65
dtcvasc() Converts an ANSI-compliant character string to a datetime value B-67
dtcvfmtasc() Converts a character string with a specified format to a datetime value B-70
dtextend() Changes the qualifier of a datetime value B-74
dtsub() Subtracts one datetime value from another B-77
dtsubinv() Subtracts an interval value from a datetime value B-80
dttoasc() Converts a datetime value to an ANSI-compliant character string B-82
dttofmtasc() Converts a datetime value to a character string with a specified format B-85
incvasc() Converts an ANSI-compliant character string to an interval value B-265
incvfmtasc() Converts a character string with a specified format to an interval value B-268
intoasc() Converts an interval value to an ANSI-compliant character string B-271
intofmtasc() Converts an interval value to a character string with a specified format B-271
invdivdbl() Divides an interval value by a numeric value B-274
invdivinv() Divides an interval value by another interval value B-277
invextend() Extends an interval value to a different interval qualifier B-280
invmuldbl() Multiplies an interval value by a numeric value B-282

For more information on operations on the SQL DATETIME and INTERVAL data types, see the Informix Guide to SQL: Reference.

INFORMIX-ESQL/C Programmer's Manual, Version 9.21
Copyright © 1999, Informix Software, Inc. All rights reserved