Skip site navigation (1)
Skip section navigation (2)
We noticed that several records which have a time stamp column have the same time stamp which i can understand given the time stamps have 1 microsecond resolution.
Peripheral Links
Header And Logo
|
Site Navigation
timestamps-accuracy
- From: Justin <justin(at)emproshunts(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: timestamps-accuracy
- Date: Fri, 09 May 2008 04:59:30 -0400
- Message-id: <48241272(dot)8080109(at)emproshunts(dot)com>
We noticed that several records which have a time stamp column have the same time stamp which i can understand given the time stamps have 1 microsecond resolution.
generail this don't hurt us but we have some needs with data coming from manufacturing testing applications that needs to keep the timestamps to .000,000,001 aka 1 nano second. what would be the easiest way to do this? Just as mind numbing we actual measure electrical resistance out that far to and have to keep track of it in the database.
- Follow-Ups:
- Re: timestamps-accuracy
- From: Martijn van Oosterhout
- Re: timestamps-accuracy
- Prev by Date: reproducible database crash with simple sql command on postgres 8.3.1
- Next by Date: Re: timestamps-accuracy
- Previous by thread: reproducible database crash with simple sql command on postgres 8.3.1
- Next by thread: Re: timestamps-accuracy
- Indexes: