17.10 - getPeriodType(int) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
Returns the Period value for the specified column. The following are the valid values for the Period type value:
NOT_PERIOD = 0
    PERIOD_DATE = 1
    PERIOD_TIME = 2
    PERIOD_TIME_WTZ =3
    PERIOD_TIMESTAMP = 4
    PERIOD_TIMESTAMP_WTZ = 5

The method throws SQLException if an error occurs while attempting to access the Period type information.

Syntax

int getPeriodType(int  column)
   throws SQL Exception