17.10 - Example: Setting Non-Working Days - 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)

In the following, Saturday and Sunday of each week of the Teradata business calendar are defined as non-working days (non-working days have the OFF status) and this information is added to the DBC.BusinessCalendarPattern table.

By default, each day of week for the Teradata business calendar is a working day.
EXEC DBC.CreateBusinessCalendarPattern
   ('TERADATA', ‘SATURDAY’,’OFF’, ‘Non-work Day’);
EXEC DBC.CreateBusinessCalendarPattern
   ('TERADATA', ‘SUNDAY’,’OFF’, ‘Non-work Day’);