Re: BUG #4523: TO_CHAR function : the ".US" format returns incorrect value - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4523: TO_CHAR function : the ".US" format returns incorrect value
Date
Msg-id 16976.1226506161@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4523: TO_CHAR function : the ".US" format returns incorrect value  ("Moussard" <evelyne.moussard@cartes-bancaires.com>)
List pgsql-bugs
"Moussard" <evelyne.moussard@cartes-bancaires.com> writes:
> Using the "TO_CHAR" function, the ".US" format doesn't display the correct
> value for the microseconds part of a timestamp value.

If you're using floating-point timestamps, this isn't a bug --- it's
just inevitable platform-specific roundoff error.  The particular test
case works as expected on the two machines I tried it on, but that
doesn't prove much of anything.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Next
From: "Hiroshi Saito"
Date:
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows