Skip to content
pgxsinkit

NOW_MICROSECONDS_SQL_TEXT

const NOW_MICROSECONDS_SQL_TEXT: "CAST(FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000000) AS BIGINT)" = "CAST(FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000000) AS BIGINT)"

Defined in: packages/contracts/src/sql-defaults.ts:11

The BODY of the canonical microsecond clock — clock_timestamp() epoch microseconds as BIGINT. This text is the SINGLE source for the public.pgxsinkit_clock_us() function body rendered by the server’s utilities migration (renderPgxsinkitUtilitiesMigration) and NOTHING else. No column DEFAULT and no generated apply-function DDL may embed this expression — every surface CALLS the function (CLOCK_US_CALL_SQL_TEXT / clockMicrosecondsSql), so the semantic choices (clock_timestamp() over now(); FLOOR + BIGINT) live in exactly one reviewable body.