Skip to main content

format_timestamptz

Function format_timestamptz 

Source
pub fn format_timestamptz(micros: i64) -> String
Expand description

Render a Timestamp (microseconds since epoch) as YYYY-MM-DD HH:MM:SS[.fff...]. Trailing-zero fractional digits are dropped; a whole-second value has no fractional part. v7.15.0 — PG-canonical TIMESTAMPTZ wire format. Storage is the same i64 microseconds UTC as TIMESTAMP, but the canonical PG text output appends the session’s UTC-offset suffix (+00 for the default UTC session, the form pg_dump emits). Mailrs round-8 acceptance criterion: SELECT col FROM tstz should round-trip to a literal that re-INSERTs without semantic drift.