© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
1 reply
brasileiro

Select clause with interval

Hi folks, how can I use interval + comparator at select clause with supabase-js?

 sql
select created_at < now() - interval '7 days'
from invite_member;
 sql
select created_at < now() - interval '7 days'
from invite_member;


I want to get a boolean if the created_at invite was in the last 7 days or not. I'm getting an error saying something like that "now is not a public table."
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Date interval?
SupabaseSSupabase / help-and-questions
4y ago
Issue with SELECT Policy
SupabaseSSupabase / help-and-questions
3mo ago
select with multiple relationships
SupabaseSSupabase / help-and-questions
4y ago
Running Edge Functions at set interval
SupabaseSSupabase / help-and-questions
4y ago