17.10 - Sys_Calendar.BusinessCalendarExceptions - 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)

This view provides information about exceptions defined for a calendar, such as a holiday on Monday, which is normally a working day. You can query the view to check the exceptions.

View Column Name Description Data Type Format
CalendarName The name of the calendar. VARCHAR(128) X(128)
ExceptionIndicator Returns ON for a working day and OFF for a nonworking day. VARCHAR(3) X(3)
ExceptionDate The exception date set for the calendar. DATE YY/MM/DD
ExceptionReason The reason for the exception. VARCHAR(1024) X(1024)
CreatorName The user who created the exception. VARCHAR(128) X(128)
CreationTime The timestamp of exception creation. TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS