From 09d775c57b69c661a8de692c1b4a417331d5ac57 Mon Sep 17 00:00:00 2001 From: Joe Banks Date: Tue, 27 Oct 2020 02:43:59 +0000 Subject: Remove unnecessary timestamp conversion --- pydis_site/apps/api/models/bot/metricity.py | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'pydis_site') diff --git a/pydis_site/apps/api/models/bot/metricity.py b/pydis_site/apps/api/models/bot/metricity.py index 4313d2e2..60b2e73d 100644 --- a/pydis_site/apps/api/models/bot/metricity.py +++ b/pydis_site/apps/api/models/bot/metricity.py @@ -54,11 +54,7 @@ class Metricity: COUNT(*) FROM ( SELECT - to_timestamp( - floor((extract('epoch' from created_at) / %d )) - * %d - ) - AT TIME ZONE 'UTC' AS interval + (floor((extract('epoch' from created_at) / %d )) * %d) AS interval FROM messages WHERE author_id='%s' -- cgit v1.2.3