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.

SQL-Abfrage für zuletzt erstellte Benutzer der letzten 30 Tage

Unterstützung

pfaffman (Jay Pfaffman) 15. August 2022 um 14:56 2

Sie könnten sich Beispiele unter Topics tagged data-explorer oder Discourse Data Explorer oder Welche coolen Data Explorer-Abfragen haben Sie entwickelt? ansehen.

Thema		Antworten	Aufrufe
Active users in the last 30 days Data & reporting sql-query	3	399	5. September 2016
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	8	1504	11. Juli 2021
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	180	1. Mai 2016
Show data for last X days Data & reporting sql-query	3	502	24. Januar 2022
User_stats with a proper time stamp Data & reporting sql-query	8	1098	15. August 2023

SQL-Abfrage für zuletzt erstellte Benutzer der letzten 30 Tage

Verwandte Themen