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); - calname
- The name of the source calendar.
Description
The equivalent API function is ts_cal_pattstartdate().
Returns
The start date of the pattern for the specified calendar.
Example
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;