Received: from p1.selectacast.net (p1.selectacast.net [206.41.1.251]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f47JL6A48323; Mon, 7 May 2001 15:21:06 -0400 (EDT) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@xtenit.dialup.access.net [166.84.206.91]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id PAA04881; Mon, 7 May 2001 15:20:58 -0400 Message-ID: <3AF6F5A1.CAD0C576@selectacast.net> Date: Mon, 07 May 2001 15:21:05 -0400 From: Joseph Shraibman Organization: Xtenit, Inc. http://www.xtenit.com X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: David Wall CC: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Timestamp Resolution in Postgres References: <9cs8hn$125n$1@news.tht.net> <015301c0d711$a5c5e680$5a2b7ad8@expertrade.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/321 X-Sequence-Number: 9106 You can edit the file src/backend/utils/adt/datetime.c and recompile. David Wall wrote: > > > 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 > > This is a frustration that I also ran into, but there's no clean way to > handle it, especialy when using JDBC which takes the default String format > for a date, and therefore the thousandth of a second number is always > dropped. It's odd, though, since the database itself claims to support down > to millionths or nanos or some such thing. But I've not heard any mention > about how to change the default format to include more digits. > > The alternatives appear to be: 1) don't worry about unless that extra > "resolution" really matters -- you know the system clock is not that > accurate anyway; 2) store it in an INT8/long... > > David > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com