我尝试按照下面的链接自行解决，但无法足够快地完成。我只想计算主题创建日期和今天的日期之间的差值，以便能够说“这个主题已经存在 6 天了”。这是我正在使用的两个字段： to_char(date_trunc(‘DAY’, t.created_at)::date,‘DD/MM/YYYY’) AS “主题创建日期”， to_char(date_trunc(‘DAY’, now())::date,‘DD/MM/YYYY’) AS “今天日期” PostgreSQL: Documentation: 9.6: Date/Time Functions and Operators 谢谢。

[图片] Sophie Strong: What I would simply like to do is a date diff between topic created date and today’s date to be able to say “this topic is 6 days old” I think you could simplify that to something like: SELECT t.id AS topic_id, CURRENT_DATE - t.created_at::date AS days_old FROM t…

两个日期之间的DATEDIFF

社区数据与报告

SStrong (Sophie Strong) 2024 年8 月 29 日 12:31 3

太好了——非常感谢！

1 个赞

话题		回复	浏览量
Filter users likes out if account created x days prior to topic creation Data & reporting sql-query	10	794	2022 年7 月 22 日
Data Explorer query for topics N+ days old, that are unsolved Data & reporting sql-query	3	593	2023 年7 月 19 日
Looking to build a custom report - time between last two responses on a topic Data & reporting sql-query	2	200	2024 年3 月 15 日
Dashboard Report - Topics Data & reporting dashboard-reports , sql-query , dashboard-sql	0	421	2023 年12 月 12 日
Timeline timestamp not updating Bug	5	558	2023 年3 月 14 日

两个日期之间的DATEDIFF

相关话题