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…

[image] 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 FRO…

Datediff between two dates

Data & reporting

SStrong (Sophie Strong) August 29, 2024, 12:31pm 3

Excellent - thanks so much for this

1 Like

Topic		Replies	Views
Recently Read Topics by User Data & reporting sql-query	0	150	May 4, 2016
Last 7 days of topics Support	9	690	June 8, 2024
Switch "Activity since" to actual date after a week, not a month? Support	3	606	June 8, 2024
Filter users likes out if account created x days prior to topic creation Data & reporting sql-query	10	768	July 22, 2022
How I can sort topics by topic creation date? Support	10	2748	March 5, 2015

Datediff between two dates

Related topics