I'm trying to get the difference between a due date and the system date in Teradata SQL using Toad.

SELECT
RECORD_ID,
DUE_DATE,
(DUE_DATE - CURRENT_DATE) DaysDiff

FROM TABLENAME

It returns an error: "Invalid operation for DateTime or Interval."