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™.
Calendar routinesYou can use calendar routines to manipulate calendars.
CalStamp functionThe CalStamp function returns the time stamp at a specified number of calendar intervals after a specified time stamp.

CalStamp function

The CalStamp function returns the time stamp at a specified number of calendar intervals after a specified time stamp.

Syntax

CalStamp(cal_name    lvarchar, 
         tstamp      datetime year to fraction(5), 
         num_stamps  integer) 
returns datetime year to fraction(5);

cal_name: The name of the calendar.
tstamp: The input time stamp.
num_stamps: 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 API function is ts_cal_stamp().

Returns

The time stamp that represents the specified offset.

Example

The following example returns the time stamp that is two intervals after 2011-01-03:

execute function CalStamp('daycal', 
   '2011-01-03 00:00:00.00000', 2);