Home
Extending Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
extensions and modulesThese topics describe how to use built-in database extensions and separately installed modules.
TimeSeries Data User's GuideThe HCL OneDB™ TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL OneDB™.
Time series API routinesThe time series application programming interface routines allow application programmers to directly access a time series datum.
The ts_cal_stamp() function

The ts_cal_stamp() function

The ts_cal_stamp() function returns the time stamp at a given number of calendar intervals before or after a given time stamp. The returned time stamp is located in allocated memory, so the caller should free it using mi_free().

Syntax

mi_datetime *
ts_cal_stamp (MI_CONNECTION *conn, 
              mi_string     *cal_name, 
              mi_datetime   *tstamp, 
              mi_integer    offset)

conn: A valid connection.
cal_name: The name of the calendar.
tstamp: The input time stamp.
offset: The number of calendar intervals before or after the input time stamp. Use a negative number to indicate an offset before the specified time stamp and a positive number to indicate an offset after the specified time stamp.

Description

The equivalent SQL function is CalStamp.

Returns

The time stamp representing the given offset, which must be freed by the caller.