X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CFC4552D6 for ; Wed, 16 Mar 2005 22:58:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48053-07 for ; Wed, 16 Mar 2005 22:58:04 +0000 (GMT) Received: from floppy.pyrenet.fr (unknown [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5F19352A62 for ; Wed, 16 Mar 2005 22:58:00 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 9AF4230959; Wed, 16 Mar 2005 23:58:01 +0100 (MET) From: "mroyce@gmail.com" X-Newsgroups: pgsql.sql Subject: timestamp precision - can I control precision at select time or set for all time? Date: 16 Mar 2005 14:57:56 -0800 Organization: http://groups.google.com Lines: 13 Message-ID: <1111013876.573335.284450@o13g2000cwo.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: o13g2000cwo.googlegroups.com; posting-host=63.251.108.11; posting-account=XRFakg0AAAADXh4wz4e5kyKndSlblJmh To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/271 X-Sequence-Number: 20750 I have a database with several tables that use timestamp without time zone type. I upgraded from an older pgsql and have code that does not expect the precision in the select output. Is there a way I can get the effect of zero precision without modifying all the tables? The docs say it usees "default precision" as set in the "timestamp literal". I wasn't able to find docs describing what literals are. If there's a way I can set this to zero precision for everything, that'd save me a bunch of time. with thanks, Royce