Shruthi A <shruthi.iisc@xxxxxxxxx> writes: > 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. I suppose what you're really asking about is not the precision of the datatype but the precision of now() readings. You're out of luck --- Windows just doesn't expose a call to get the wall clock time to better than 1 msec. Keep in mind that whatever the Linux machine is returning might be largely fantasy in the low-order bits, too. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
