CODEWITHSUNDEEP
postgresql
CallMeNorm
CallMeNorm

Reputation: 2605

postgres removes microseconds from now()

My local postgres instance, version 12, removes the microseconds from my timestamp.

The column type is timestamp with out time zone. My query is UPDATE trash SET updated_at = now() WHERE id = 164 and when I do select id, updated_at FROM trash WHERE id = 164 the microseconds are gone.

However, SELECT now() returns micrsoseconds.

Is there some configuration or something else that would help me understand why the microseconds aren't persisted?

Upvotes: 0

Views: 305

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246798

I bet updated_at is of type timestamp(0) so that it discards fractional seconds.

Upvotes: 1

Related Questions