DATE-to-Numeric Conversion - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Introduction

DATE data may be converted to the following numeric types:
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL(n, m)
  • NUMBER
  • FLOAT

CAST Syntax



date_expression

A date expression to be converted.

numeric_data_type

The data type to which the expression is to be converted.

data_attribute
One of the following data attributes:
  • FORMAT
  • NAMED
  • TITLE