How do I get the date from seven days ago?


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

I tried to use this code but it errors out.

I also tried

It gives me this error

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


In Redshift, I would write this as:

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

Leave a Reply