trevor1940
asked on
Syntax how to select past 7 days from PostgreSQL table
Hi
I'm Trying to create a view PostgreSQL where I select from my Table where date = past 7 or 14 days
Can Someone help with the Syntax?
Do I need to create 2 views or can I pass it either 7 or 14 as a variable?
I'm Trying to create a view PostgreSQL where I select from my Table where date = past 7 or 14 days
Can Someone help with the Syntax?
Do I need to create 2 views or can I pass it either 7 or 14 as a variable?
ASKER
Thanx any idea what the syntax is for the past 7 days?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
so you shall create 2 views unless you want to filter on the 14-days view to fetch 7days