Business Calendars | SQL Date/Time Functions & Expressions | Teradata Vantage - Business Calendars - 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™

A business calendar defines business and non-business days. The significance of a day being a business day or a non-business day is user-determined. For example, a business day could be a work day, and a non-business day could be either a non-working day, a weekend day, a holiday, or a vacation day. You can define different week patterns (weekdays and weekends) and exceptions (holidays and business open and closed days) for the system-defined calendars.

There are three Teradata system-defined business calendars you can set for your session:
  • Teradata
  • ISO
  • COMPATIBLE

All three calendars are based on the Gregorian calendar. The Gregorian calendar has 365 days in most years and 366 days in a leap year. The calendars differ in how they define weeks and whether they allow partial weeks. You can use macros to specify weekday/weekend patterns and exceptions to the patterns.

The calendars support January 1, 1900, to December 31, 2100. The default session calendar is Teradata. Each calendar defaults to all business days. You can change that pattern using a macro. See Business Calendar Macros.