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 6A71BD1B4D8 for ; Tue, 3 Aug 2004 07:45:44 -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 23961-03 for ; Tue, 3 Aug 2004 10:45:39 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id C5E83D1B366 for ; Tue, 3 Aug 2004 07:44:27 -0300 (ADT) Received: from oniweb3.oninet.pt (unknown [195.245.128.29]) by www.postgresql.com (Postfix) with ESMTP id 424A6CF5645 for ; Tue, 3 Aug 2004 04:28:06 -0300 (ADT) Received: from filo.at.isp ([195.245.128.200]) by oniweb3.oninet.pt with Microsoft SMTPSVC(5.0.2195.6713); Tue, 3 Aug 2004 08:28:22 +0100 Received: from [213.58.190.132] ([213.58.190.132]) by filo.at.isp with Microsoft SMTPSVC(5.0.2195.6713); Tue, 3 Aug 2004 08:22:27 +0100 Message-ID: <410F3D4B.60405@netcabo.pt> Date: Tue, 03 Aug 2004 08:22:51 +0100 From: "Pedro B." User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Datetime References: <77ED2BF75D59D1439F90412CC5B109740E8A2E38@ie10-sahara.hiso.honeywell.com> <40EBD891.3050205@archonet.com> <005801c464dd$72b5bec0$0403a8c0@fejleszt4> <40ED4DE5.7020807@netcabo.pt> In-Reply-To: <40ED4DE5.7020807@netcabo.pt> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 03 Aug 2004 07:22:28.0156 (UTC) FILETIME=[A1B15FC0:01C4792A] 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/19 X-Sequence-Number: 18516 Hello, 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. Thanks, \\pb