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™.
Calendar pattern routinesYou can use calendar pattern routines to manipulate calendar patterns.
CalPattStartDate functionThe CalPattStartDate function takes a calendar name and returns a DATETIME containing the start date of the pattern for that calendar.

CalPattStartDate function

The CalPattStartDate function takes a calendar name and returns a DATETIME containing the start date of the pattern for that calendar.

Syntax

CalPattStartDate(calname lvarchar) 
returns datetime year to fraction(5);

The equivalent API function is ts_cal_pattstartdate().

The start date of the pattern for the specified calendar.

The following example returns the start dates of the calendar patterns for each calendar in the CalendarTable table:

select c_name, CalPattStartDate(c_name) from CalendarTable;