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.

Consulta SQL para los últimos usuarios creados en los últimos 30 días

Soporte

pfaffman (Jay Pfaffman) 15 Agosto, 2022 14:56 2

Puede echar un vistazo a Topics tagged data-explorer o Discourse Data Explorer o ¿Qué consultas geniales de Data Explorer se te han ocurrido? para ver algunos ejemplos.

Tema		Respuestas	Vistas
Active users in the last 30 days Data & reporting sql-query	3	399	5 Septiembre 2016
SQL query for users who have posted on a date (or date range) Data & reporting sql-query	8	1504	11 Julio 2021
Users Last Seen Since (Since N Days Ago) Data & reporting sql-query	0	180	1 Mayo 2016
Show data for last X days Data & reporting sql-query	3	502	24 Enero 2022
User_stats with a proper time stamp Data & reporting sql-query	8	1098	15 Agosto 2023

Consulta SQL para los últimos usuarios creados en los últimos 30 días

Temas relacionados