access_time 12 months ago languageEnglish
more_vert

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

visibility 6,123 comment 0

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 6 months ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts