✨ [ClickBench] Timestamp functions on Unix Epoch timestamps

[joocer]

Functions which work on dates and timestamps generally don't work on Linux Epoch timestamps

extract(minute FROM EventTime)

┌────┬────────────┐
│    │ EventTime  │
│    │  INTEGER   │
╞════╪════════════╡
│  1 │ 1373834327 │
│  2 │ 1373913230 │
│  3 │ 1373914595 │
│  4 │ 1373914712 │
│  5 │ 1373833834 │
│  6 │ 1373841641 │
│  7 │ 1373916373 │
│  8 │ 1373917016 │
│  9 │ 1373912311 │
│ 10 │ 1373851126 │
└────┴────────────┘

[joocer]

and

SELECT URL, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND URL <> '' GROUP BY URL ORDER BY PageViews DESC LIMIT 10;