Business Calendar Macros | SQL Date/Time Functions & Expressions | Vantage - Business Calendar Macros - Analytics Database - Teradata Vantage

SQL Date and Time Functions and Expressions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantage™
System business macros enable administrators and users to configure the system business calendars (Teradata, ISO, and COMPATIBLE) by:
  • Creating the pattern for the calendar.
  • Creating exceptions for the calendar.
  • Deleting existing exceptions from the calendar.

These macros are created when the DIP script is executed and reside in the DBC database.

To view any of the macros, use the DIP script.
Macro Name Purpose
CreateBusinessCalendarPattern Creates the pattern for a business calendar.
CreateException Defines an exception list for a specific business calendar. The list identifies all of the days of the calendar that are exceptions to the pattern defined for the calendar.
DeleteException Deletes a particular exception from a specific business calendar.
DeleteAllExceptions Deletes all of the exceptions from a specific business calendar.