# Users ordered by creation date

**URL:** https://meta.discourse.org/t/users-ordered-by-creation-date/275009
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [6월 22, 2017, 12:37오전 UTC](https://meta.discourse.org/t/users-ordered-by-creation-date/275009 "2017-06-22T00:37:26Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)
#### Post date: [6월 22, 2017, 12:37오전 UTC](https://meta.discourse.org/t/users-ordered-by-creation-date/275009/1 "2017-06-22T00:37:26Z")

</div>

### Users ordered by creation date

```sql
SELECT users.username, users.created_at
FROM users
WHERE users.created_at < '2017-05-10'::timestamp
ORDER BY users.created_at

```