# "First Flag"徽章拥有精确的公开时间戳，可与被标记的帖子相关联。

**URL:** <https://meta.discourse.org/t/first-flag-badge-has-precise-public-timestamps-that-could-be-correlated-with-flagged-posts/187710>\
**Category:** Feature\
**Tags:** badges\
**Created:** [2021 年4 月 22 日 04:59 UTC](https://meta.discourse.org/t/first-flag-badge-has-precise-public-timestamps-that-could-be-correlated-with-flagged-posts/187710 "2021-04-22T04:59:43Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

作者： ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)\
发布日期： [2021 年4 月 23 日 06:59 UTC](https://meta.discourse.org/t/first-flag-badge-has-precise-public-timestamps-that-could-be-correlated-with-flagged-posts/187710/4 "2021-04-23T06:59:41Z")

</div>

在查询中修复它应该很简单，只需使用 `date_trunc('hour', flag.created_at) as granted_at`，但考虑到徽章本身是否应该存在也是一个很好的观点。

---

_[View the full topic](https://meta.discourse.org/t/first-flag-badge-has-precise-public-timestamps-that-could-be-correlated-with-flagged-posts/187710)._