SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE timeslices ( id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY, created_at TIMESTAMPTZ, finished_at TIMESTAMPTZ ); INSERT INTO timeslices (created_at, finished_at) VALUES ( '2022-05-26 17:55:05.123208+00', '2022-05-26 17:59:05.670208+00' ); SELECT * FROM timeslices; TRUNCATE TABLE timeslices RESTART IDENTITY; INSERT INTO timeslices (created_at, finished_at) VALUES ( '2022-05-26 10:12:06.720017+00', '2022-05-26 10:15:06.100017+00' ), ( '2022-05-26 07:26:50.715445+00', '2022-05-26 07:30:50.715445+00' ), ( '2022-05-26 17:55:05.123208+00', '2022-05-26 17:59:05.670208+00' ); SELECT * FROM timeslices;