17.00 - 17.05 - Example: Setting Non-Working Days - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Programming Reference
Publication ID
B035-1211-170K
Language
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’);