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) 8월 15, 2022, 2:56오후 2

예시를 확인하려면 Topics tagged data-explorer 또는 Discourse Data Explorer 또는 What cool data explorer queries have you come up with?를 참고해 보세요.

글		댓글	조회수
Active users in the last 30 days Data & reporting sql-query	3	470	9월 5, 2016
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	7	1631	10월 18, 2018
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	203	5월 1, 2016
Show data for last X days Data & reporting sql-query	2	563	1월 24, 2022
User_stats with a proper time stamp Data & reporting sql-query	7	1209	3월 2, 2020

최근 30일간 생성된 사용자 목록을 가져오는 SQL 쿼리

Related topics