Substract X amount of weeks

1

As the subject, how do I subtract 5 weeks from the current date?

I was able to use
SELECT TIMESTAMPADD( YEAR, -1, CURRENT_DATE)

however, I got “SQL Error: PARSE ERROR: Failure parsing the query” error by changing YEAR to week or ‘week’.

SELECT TIMESTAMPADD( week, -1, CURRENT_DATE)
SELECT TIMESTAMPADD( ‘week’, -1, CURRENT_DATE)

what am I supposed to do if I want to subtract 5 weeks from today?

thank you

2

@chun2869

You can use DAY or MONTH

select DATE_SUB(now(), INTERVAL '10' DAY)
select DATE_SUB(now(), INTERVAL '10' MONTH)