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

You might have a look in Topics tagged data-explorer or Discourse Data Explorer or What cool data explorer queries have you come up with? for some examples.

过去30天内最后创建用户的SQL查询

支持

pfaffman (Jay Pfaffman) 2022年八月15日 14:56 2

您可以查看 Topics tagged data-explorer 或 Discourse Data Explorer 或您想出了哪些很棒的数据浏览器查询？来获取一些示例。

話題		回覆	觀看
Active users in the last 30 days Data & reporting sql-query	3	449	2016年九月5日
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	7	1593	2018年十月18日
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	194	2016年五月1日
Show data for last X days Data & reporting sql-query	2	545	2022年一月24日
User_stats with a proper time stamp Data & reporting sql-query	7	1182	2020年三月2日

过去30天内最后创建用户的SQL查询

相關主題