Example: Converting numeric_value into an INTERVAL YEAR(40) TO MONTH Value - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

The following query:

SELECT NUMTOYMINTERVAL(40, 'YEAR');

returns the result '40-00', which is 40 years, 0 months.