15.00 - Prerequisites - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)
Last Update


Before you can use these functions, you must run the Database Initialization Program (DIP) utility and run the DIPUDT script. The DIPALL and DIPUDT scripts create the calendar functions in the SYSLIB database. For more information about the DIP utility, see Utilities: Volume 1 (A-K).

If you have a user-developed UDF with the same name as a calendar function, you must remove that user-developed UDF from the normal UDF search path before you can invoke the calendar function. If the calendar function is not found in the current database, Teradata Database searches for the function in the SYSLIB database. Alternatively, you may invoke the calendar function by using the fully qualified syntax, SYSLIB.calendar_function_name.