Home
Extending HCL OneDB™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 DataBlade® 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™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® 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_time() function

The ts_time() function

The ts_time() function converts a regular time series offset to a time stamp.

Syntax

mi_datetime *
ts_time(ts_tsdesc  *tsdesc, 
         mi_integer N)

ts_desc: The time series descriptor returned by ts_open() for the source time series.
N: The offset to convert. Negative values are allowed.

Description

For example, for a daily time series that starts on Monday, January 1, with a five-day-a-week pattern starting on Monday, this function returns Monday, January 1, when the argument is set to 0; Tuesday, January 2, when the argument is set to 1; Monday, January 8, when the argument is 5; and so on.

The equivalent SQL function is GetStamp.

Returns

The time stamp corresponding to the offset. This value must be freed by the user with mi_free().