Kontext Copilot - An AI assistant for data analytics. Learn more
Expression of Interest
Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months
insights Stats
warning Please login first to view stats information.
Raymond
Code Snippets & Tips
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
In ANSI SQL, you can use DATEADD function to easily add or subtract days/week/months/years from a date as the following code snippet shows:
SELECT DATEADD(month, 1, '20060830');
SELECT DATEADD(day, -1, '20060831');
However in Teradata this function is not implemented and you can use interval to add or subtract date units from date types.
Code snippets
Add days
select EmployeeID,Birthday, Birthday + Interval '2' day from TD_MS_SAMPLE_DB.Employee
Subtract days
select EmployeeID,Birthday, Birthday - Interval '2' day from TD_MS_SAMPLE_DB.Employee;
Add months
select EmployeeID,Birthday, Birthday + Interval '3' month from TD_MS_SAMPLE_DB.Employee
Subtract months
select EmployeeID,Birthday, Birthday - Interval '3' month from TD_MS_SAMPLE_DB.Employee
info Last modified by Administrator 5 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.