timestamp9

pig build pkg timestamp9;		# build deb

pig repo add pgsql -u   # add both repo and update cache

pig install timestamp9;		# install via package name, for the active PG version

pig install timestamp9 -v 18;   # install for PG 18
pig install timestamp9 -v 17;   # install for PG 17
pig install timestamp9 -v 16;   # install for PG 16
pig install timestamp9 -v 15;   # install for PG 15
pig install timestamp9 -v 14;   # install for PG 14

CREATE EXTENSION timestamp9;

CREATE EXTENSION timestamp9;

-- Standard PostgreSQL format
SELECT '2019-09-19 08:30:05'::timestamp9;

-- Full nanosecond precision with timezone
SELECT '2019-09-19 08:30:05.123456789 +0200'::timestamp9;

-- Cast from bigint (nanoseconds since epoch)
SELECT 1568878205123456789::bigint::timestamp9;

-- Comparison
SELECT '2019-09-19'::timestamp9 > '2019-09-18'::timestamp9;  -- true

-- Arithmetic with intervals
SELECT '2019-09-19 23:00:00.123456789'::timestamp9 + interval '1 day';

-- Subtraction
SELECT '2019-09-20'::timestamp9 - '2019-09-19'::timestamp9;

SELECT greatest('2019-09-19'::timestamp9, '2019-09-20'::timestamp9);