john.ud...@zionsbancorp.com writes: > I would expect that at the time/date of the of now() and clock_timestamp() > to be equal; which they are.
Well, they are not in general, but that doesn't appear to be your problem. You have not shown us a reproducible test case, but I wonder whether your table has a trigger that is doing date_trunc('year',...) or something like that on the column value. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs