languageEnglish

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

visibility 12,099 comment 0 access_time 2 years ago

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 2 years ago copyright This page is subject to Site terms.

Subscribe newsletter

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext

visibility 114
thumb_up 0
access_time 6 months ago
visibility 8562
thumb_up 0
access_time 12 months ago