Period Type Input & Output Parameters | Data Types & Literals | Teradata Vantage - Period Type Input and Output Parameters - Teradata Vantage - Analytics Database

SQL Data Types and Literals
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Publication Date
June 2022
Content Type
Data Types
SQL Reference
Publication ID
B035-1143-172K
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
ft:sourceId
dita
dita:id
exs1472253032394
lifecycle
latest
Product Category
Teradata Vantage™

You can specify a Period type as a parameter or return type for UDFs written in C, C++, or Java. This includes scalar and aggregate UDFs, table functions, and table operators.

You can specify a Period type as an IN, INOUT, or OUT parameter of stored procedures and external stored procedures written in C, C++, or Java.

You can specify a Period type as a parameter or return type for UDMs written in C or C++.

FNC functions and Java classes and methods are provided to enable a UDF, UDM, or external stored procedure to access and set the value of a Period parameter, or to get information about the Period type parameter. For information about these functions and methods, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.