| 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: | Whole Thread | Raw Message | 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 |