timestamp9

pig build pkg timestamp9         # build DEB packages

pig repo add pgdg -u          # Add PGDG repo and update cache

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);