How to get all users that signed up in the last 30 days? I suppose I need some builtin SQL function to generate this date format and then do -30 days. I’ve tried a few examples from the Interwebz, such as this , but I get a syntax error. WITH query_period AS ( SELECT date_trunc('month', CURRENT_DATE…

Got it. SELECT username FROM users WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '30 days' AND staged = false

過去30日間の最後に作成されたユーザーのSQLクエリ

pfaffman (Jay Pfaffman) 2022 年 8 月 15 日午後 2:56 2

「いいね！」 1

トピック		返信	表示
Active users in the last 30 days Data & reporting sql-query	3	346	2016 年 9 月 5 日
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	8	1464	2021 年 7 月 11 日
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	159	2016 年 5 月 1 日
Show data for last X days Data & reporting sql-query	3	476	2022 年 1 月 24 日
User_stats with a proper time stamp Data & reporting sql-query	8	1031	2023 年 8 月 15 日