Teradata internally stores the date as INTEGER. Calculate dates after January 1st, 1900 using this formula: ((year- 1900) * 10000) ...

Efficient Teradata Date Calculations Avoiding INTEGER Values

 Introduction to Teradata Recursions To link records from a primary table with a specific date range from a secondary table, ...

An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table