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 002E3D1B340 for ; Tue, 3 Aug 2004 07:58:36 -0300 (ADT) 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 31753-01 for ; Tue, 3 Aug 2004 10:58:29 +0000 (GMT) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id D13EFD1B341 for ; Tue, 3 Aug 2004 07:58:27 -0300 (ADT) Received: by emo.org.tr (Postfix, from userid 41643) id 6F6CF2FDAD; Tue, 3 Aug 2004 13:58:26 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 65D4711218E; Tue, 3 Aug 2004 13:58:26 +0300 (EEST) Date: Tue, 3 Aug 2004 13:58:26 +0300 (EEST) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: "Pedro B." Cc: pgsql-sql@postgresql.org Subject: Re: Datetime In-Reply-To: <410F3D4B.60405@netcabo.pt> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/21 X-Sequence-Number: 18518 Hi, On Tue, 3 Aug 2004, Pedro B. wrote: > I'm using a TIMESTAMP column with a now() default which (correctly i > assume) uses a 'yyyy-mm-dd hh:mm:ss' format. > > Is it possible to make it something like 'yyyy-mm-dd hh:mm:ss:cc' ? > (basically, a DATE and a TIME, but with 2 decimal cases on the :cc and > not .ccccc as the TIME format. Is this what you are asking? test=> SELECT now()::timestamp(1); now ------------------------ 2004-08-03 13:58:48.60 (1 row) Regards, -- Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org