17.10 - getBasePrecision() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Retrieves the precision for the base type of the UDT or complex type. This value corresponds to the precision for time or timestamp types; for example TIME(4) or TIMESTAMP(6), otherwise it is set to zero.

The method returns a constant of type int that contains the precision value.

The method throws SQLException if an error occurs while attempting to access the precision value. A database specific code “9744 (ERRUDFJAVUDT) <UDT base precision could not be accessed>” is returned.


int getBasePrecision()
                       throws SQLException