Question: how to subtract days from a date in teradata?
Answer: Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months. 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');