Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE sales_events (
   
    created_at TIMESTAMPTZ
);

CREATE TABLE

INSERT INTO sales_events ( created_at)
VALUES 
( NOW()),
( NOW()),
( NOW()),
( NOW()),
( NOW());

INSERT 0 5

select * from sales_events;

created_at

2024-12-16 22:44:09.456557+00

2024-12-16 22:44:09.456557+00

2024-12-16 22:44:09.456557+00

2024-12-16 22:44:09.456557+00

2024-12-16 22:44:09.456557+00

SELECT 5

UPDATE sales_events
SET created_at = created_at - INTERVAL '3 years' * RANDOM();

UPDATE 5

select * from sales_events;

created_at

2022-07-27 14:20:39.782957+00

2023-05-16 12:57:24.826157+00

2023-12-18 05:50:54.182957+00

2024-09-15 07:11:48.480557+00

2023-01-15 08:05:10.378157+00

SELECT 5