Feature: extract timestamptz with milliseconds

[dvv]

Proposal

Improve reported timestamp precision, as naive_datetime_to_pg_timestamptz() precision ends at seconds.

Additional Links

Here https://github.com/VADOSWARE/pg_idkit/blob/main/src/uuid_v7.rs#L54C31-L54C31 we respect nanos, but here https://github.com/VADOSWARE/pg_idkit/blob/main/src/common.rs#L41 do not.

[t3hmrman]

Hey @dvv thanks for the idea -- note that the highest resolution of postgres timestamp types is microseconds, so the best we can do here is microseconds, I think!

That said, the nanos should be converted to micro seconds at least rather than leaving it at second granularity.

Would you like to work on this? If you're interested in throwing up a contribution I'd love to have it -- otherwise I can try to get to this soon!