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_o…

Excellent - thanks so much for this

Разница дат между двумя датами

Создание сообщества Данные и отчетность

SStrong (Sophie Strong) 29.Август.2024 12:31:51 3

Отлично — большое спасибо за это

Тема		Ответов	Просм.
Filter users likes out if account created x days prior to topic creation Data & reporting sql-query	9	861	22.07.2022
Data Explorer query for topics N+ days old, that are unsolved Data & reporting sql-query	2	636	19.07.2023
Looking to build a custom report - time between last two responses on a topic Data & reporting sql-query	1	221	15.03.2024
Dashboard Report - Topics Data & reporting sql-query , dashboard-reports , dashboard-sql	0	445	12.12.2023
Timeline timestamp not updating Bug	4	590	14.03.2023

Разница дат между двумя датами

Связанные темы