Raymond
Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months
insights Stats
warning Please login first to view stats information.
toc Table of contents
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 4 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.