Operations on Date and Time Data

The ESQL/C library provides the following functions to perform operations on DATETIME (mi_datetime) and INTERVAL (mi_interval) values.

Function Name

Description

dtaddinv( )

Adds an mi_interval value to a mi_datetime value

dtcurrent( )

Gets current date and time

dtsub( )

Subtracts one mi_datetime value from another

dtsubinv( )

Subtracts an mi_interval value from a mi_datetime value

invdivdbl( )

Divides an mi_interval value by a numeric value

invdivinv( )

Divides an mi_interval value by an mi_interval value

invmuldbl( )

Multiplies an mi_interval value by a numeric value

Any other operations, modifications, or analyses can produce unpredictable results.