How do I get the date from seven days ago?

Question 1

I’d like to make a chart that gives me data from last week.

I tried to use this code but it errors out.

where (time_stamp::date > dateadd(day, -7, now()::date))

1 2	where (time_stamp::date > dateadd(day, -7, now()::date))

I also tried

(ud.time_stamp::date between now() and dateadd(day, -7, now()::date))

1 2	(ud.time_stamp::date between now() and dateadd(day, -7, now()::date))

It gives me this error

Error running query: Specified types or functions (one per INFO
message) not supported on Redshift tables.

Question 2

In Redshift, I would write this as:

where time_stamp >= current_date - interval '6 day'

1 2	where time_stamp >= current_date - interval '6 day'

I suspect that time_stamp might be used for partitioning and you want to be careful about comparisons involving functions on it.

Question: