DATETIME and INTERVAL library functions
You must use the following 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 to
handle datetime and interval host variables.
Function name | Description | See |
---|---|---|
dtaddinv() | Adds an interval value to a datetime value | The dtaddinv() function |
dtcurrent() | Gets the current date and time | The dtcurrent() function |
dtcvasc() | Converts an ANSI-compliant character string to a datetime value | The dtcvasc() function |
dtcvfmtasc() | Converts a character string with a specified format to a datetime value | The dtcvfmtasc() function |
dtextend() | Changes the qualifier of a datetime value | The dtextend() function |
dtsub() | Subtracts one datetime value from another | The dtsub() function |
dtsubinv() | Subtracts an interval value from a datetime value | The dtsubinv() function |
dttoasc() | Converts a datetime value to an ANSI-compliant character string | The dttoasc() function |
dttofmtasc() | Converts a datetime value to a character string with a specified format | The dttofmtasc() function |
incvasc() | Converts an ANSI-compliant character string to an interval value | The incvasc() function |
incvfmtasc() | Converts a character string with a specified format to an interval value | The incvfmtasc() function |
intoasc() | Converts an interval value to an ANSI-compliant character string | The intoasc() function |
intofmtasc() | Converts an interval value to a character string with a specified format | The intoasc() function |
invdivdbl() | Divides an interval value by a numeric value | The intofmtasc() function |
invdivinv() | Divides an interval value by another interval value | The invdivdbl() function |
invextend() | Extends an interval value to a different interval qualifier | The invdivinv() function |
invmuldbl() | Multiplies an interval value by a numeric value | The invextend() function |
For more information about operations on the SQL DATETIME and INTERVAL data types, see the HCL OneDB™ Guide to SQL: Reference.