Joseph Shraibman <jks@selectacast.net> writes:
> This patch fixes the problem of doing:
> select '2001-08-15 23:59:59.996'::timestamp;
This seems the hardest possible way to do it. What I suggested awhile
back was to round the timestamp value to two fractional digits before
disassembling it into y/m/d/h/m/s, which'd take only something like
foo = rint(foo * 100.0) / 100.0;
at the right place. Thomas didn't like that, for reasons that I do not
recall offhand, and nothing's been done since.
regards, tom lane