Raymond Raymond

Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months

event 2020-03-15 visibility 32,370 comment 0 insights toc
more_vert
insights Stats

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
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts