16.20 - DATE - 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)

C Data Type Definition

typedef long int DATE;

Usage

The date is represented using the following formula:

((year-1900) x 10000 + (month x 100) + day)

Here is an example using DATE in a UDF definition and C function declaration.

SQL Function Definition Equivalent C Function Declaration
CREATE FUNCTION F1 (
  A DATE )
RETURNS DATE
 ...;
void f1( DATE *a,
         DATE *result,
   ... )
{  ... }