17.10 - Example: Querying with CAST - Advanced SQL Engine

17.10 - Example: Querying with CAST - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Release Date

July 2021

Content Type

Programming Reference

Publication ID

B035-1143-171K

Language

English (United States)

The following query returns ' -265-11'.

SELECT CAST('-265-11' AS INTERVAL YEAR(4) TO MONTH);