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

SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dzx1591742169550.ditamap
dita:ditavalPath
dzx1591742169550.ditaval
dita:id
B035-1211
lifecycle
previous
Product Category
Teradata Vantage™

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’);