Gunnar R|nning <gunnar@candleweb.no> writes:
>> BTW, did your original data contain any fractional-second timestamps?
>> I'm wondering if the original value might have been something like
>> 2000-10-24 15:14:59.999
>> in which case sprintf's roundoff of the seconds field to %.2f format
>> would've been enough to do the damage.
> What do you mean by original value ? The value we have in the production
> database ? If so, that shows up as 2000-10-24 15:14:60.00+02 independent of
> what platform my client is running on. The production platform was as I
> mentioned Solaris 2.7.
If you still have the value stored in the original database, please try
select date_part('seconds', ...)
to see what that reports as the true seconds part of the value.
regards, tom lane