I’ve tried following the below link to work this out myself but cannot quickly enough 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” These are the two fields I am working with: to_char(date_trunc(‘DAY’, t.crea…

[画像] 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…

Excellent - thanks so much for this

2つの日付間のDatediff

コミュニティデータとレポート

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

素晴らしい - どうもありがとうございます

トピック		返信	表示
Filter users likes out if account created x days prior to topic creation Data & reporting sql-query	10	828	2022 年 7 月 22 日
Data Explorer query for topics N+ days old, that are unsolved Data & reporting sql-query	3	622	2023 年 7 月 19 日
Looking to build a custom report - time between last two responses on a topic Data & reporting sql-query	2	212	2024 年 3 月 15 日
Dashboard Report - Topics Data & reporting dashboard-reports , sql-query , dashboard-sql	0	440	2023 年 12 月 12 日
Timeline timestamp not updating Bug	5	572	2023 年 3 月 14 日

2つの日付間のDatediff

関連トピック