Business Calendar Macros | SQL Date/Time Functions & Expressions | Vantage - 17.10 - About Business Calendar Macros - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
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.