FWIW, here is a way to extract timestamps from transaction IDs stored
with RelStorage. Kai of HexagonIT suggested it. The timestamps should
be in UTC.
PostgreSQL:
select
(tid 32) / 535680 + 1900 as year,
1 + ((tid 32) % 535680) / 44640 as month,
1 + ((tid 32) % 44640) / 1440 as
On 2011-02-03 17:37:54 +0200, Shane Hathaway said:
FWIW, here is a way to extract timestamps from transaction IDs stored
with RelStorage. Kai of HexagonIT suggested it. The timestamps should
be in UTC.
PostgreSQL:
select
(tid 32) / 535680 + 1900 as year,
1 + ((tid 32) %
Am 03.02.2011, 22:39 Uhr, schrieb Kai Lautaportti
kai.lautapor...@hexagonit.fi:
Here's a slightly different version of the MySQL query that outputs
ISO8601 formatted timestamps:
SELECT CONCAT(
CAST(((tid 32) div 535680 + 1900) AS CHAR),
'-',
LPAD(CAST((1 + ((tid 32) %