# Consulta SQL para usuarios que han publicado en una fecha (o rango de fechas)

**URL:** https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [11 Octubre, 2018 16:00 UTC](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301 "2018-10-11T16:00:37Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [11 Octubre, 2018 19:07 UTC](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301/2 "2018-10-11T19:07:40Z")

</div>

> [@Active users in the last 30 days](https://meta.discourse.org/t/active-users-in-the-last-30-days/275140?u=pfaffman):
>
> Active users in the last 30 days select username from users where last\_posted\_at \> current\_timestamp - interval '30' day

---

_[View the full topic](https://meta.discourse.org/t/sql-query-for-users-who-have-posted-on-a-date-or-date-range/99301)._