#307 ✓resolved
Derek Williams

parse_time function in do_postgres_ext.c incorrectly parses microseconds for some timestamps

Reported by Derek Williams | May 23rd, 2008 @ 08:56 PM

The recent change to allow microseconds incorrectly parses timestamps that do not have a 6 digit microsecond. Postgresql will not return all 6 digits if they are not provided with the inserted time.

In my case, the times I enter in my database are taken from photographs that only have fractions of seconds stored in the hundredths, which causes do_postgres to only read 20 usecs instead of 20000 usecs.

The included patch fixes this for me.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket