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

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