Date_Add or Date_Sub Trying to minus a year

Hi Guys,

I'm trying to minus a year from date field coming from Netsuite.

This is what I have but it doesn't seem to be working?

SELECT
DATE_SUB(ENDING, INTERVAL 1 YEAR) 'Last Year'
FROM ACCOUNTING_PERIODS

Any suggestions would be great.

Andrew

Best Answer

Answers