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_tstamp_minus() function

The ts_tstamp_minus() function

The ts_tstamp_minus() function returns a time stamp at a specified number of intervals before a starting date you specify.

Syntax

mi_datetime *
ts_tstamp_minus(mi_datetime  *startdate, 
                mi_integer   cnt,
                mi_integer   interval, 
                mi_datetime  *result)

startdate: The date to start from.
cnt: The number of intervals to subtract from the start date.
interval: The interval, as described next.
result: The resulting date.

Description

Valid values for the interval parameter can be found in tseries.h. They are:

TS_SECOND
TS_MINUTE
TS_HOUR
TS_DAY
TS_WEEK
TS_MONTH
TS_YEAR

If the result parameter is NULL, then a result mi_datetime structure is allocated and returned; otherwise, the return value is the given result parameter.

Returns

The time stamp at the specified number of intervals before the start date.