From: | Shruthi A <shruthi(dot)iisc(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Timestamp precision in Windows and Linux |
Date: | 2009-12-28 06:22:37 |
Message-ID: | 6caee9520912272222w3b20e9a6u5e7c061d8e6614f5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
The page http://www.postgresql.org/docs/7.2/static/datatype-datetime.htmlmentions
that the resolution of all time and timestamp data types is 1
microsecond. I have an application that runs on both a Windows (XP with
SP2) machine and a Linux (SUSE 10.2) machine. I saw that on postgres
enterprisedb 8.3 installed on both these machines, the default timestamp
precision on the former is upto a millisecond and on the latter it is 1
microsecond.
My curiosity is : is this a universal phenomenon ie a basic issue with
Windows? Or could there be some hardware or architectural differences or
something else...
And my problem is: is there any way to enforce a higher precision in
Windows? Because my application badly needs it.
Please help / guide.
Thanks a million,
Shruthi
From | Date | Subject | |
---|---|---|---|
Next Message | Premila Devi | 2009-12-28 08:40:20 | ERROR: syntax error at or near "group" |
Previous Message | Guillaume Lelarge | 2009-12-27 09:34:04 | Re: [pgadmin-support] [ADMIN] Background color in query tool |