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
-
Dan Kubb (dkubb) May 25th, 2008 @ 06:30 PM
- State changed from “new” to “resolved”
Resolving based on Derek's comment.
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Dan Kubb (dkubb)