Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f47CnRA63405 for ; Mon, 7 May 2001 08:49:27 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f43IuSA53702; Thu, 3 May 2001 14:56:28 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f43Ibjw35002; Thu, 3 May 2001 14:37:45 -0400 (EDT) (envelope-from news) From: "Michael Schroepfer" X-Newsgroups: comp.databases.postgresql.general,comp.databases.postgresql.sql Subject: Timestamp Resolution in Postgres Date: Thu, 3 May 2001 11:36:02 -0700 Organization: Raplix, Inc. Lines: 45 Message-ID: <9cs8hn$125n$1@news.tht.net> Reply-To: "Michael Schroepfer" X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200105/291 X-Sequence-Number: 9030 Hi All, Apologies if I posted to the wrong groups. I am trying to use the timestamp column type in postgres. It appears that postgres is rounding the milliseconds to the nearest 10ms. I'm running on Solaris 8 - and my app is written in java which is returning dates with a 1ms accuracy. Is there a setting somewhere to adjust the resolution of the timestamp field? I haven't seen anything in the documentation. Enclosed below is a simple example which exhibits the behavior. Thanks for any help! Mike Let's say I have a table called person: create table person ( OBJECTID VARCHAR( 56), BIRTHDAY TIMESTAMP, NAME VARCHAR(256) ); If I run the following command in psql: update table person set birthday = '2001-05-03 11:12:56.343' where objectid = '34'; followed by select * from person where objectid = '34'; I get : 2001-05-03 11:12:56.34-07