16.20 - Defining Functions that Use Period Types - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

A period is an anchored duration that represents a set of contiguous time granules. It has a beginning bound (defined by the value of a beginning element) and an ending bound (defined by the value of an ending element). The representation of the period extends from the beginning bound up to but not including the ending bound.

Teradata Database supports the following Period data types:
  • PERIOD(DATE)
  • PERIOD(TIME)
  • PERIOD(TIMESTAMP)

PERIOD(TIME) and PERIOD(TIMESTAMP) can be specified with optional fractional seconds, for example PERIOD(TIME(6)), and optional time zone, for example PERIOD(TIMESTAMP WITH TIME ZONE).