Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 27D744760F9; Mon,  2 Dec 2002 11:42:12 -0500 (EST)
Received: from ssmcmail.nems.noaa.gov (ssmcmail.nems.noaa.gov [205.156.4.221])
	by postgresql.org (Postfix) with ESMTP
	id 3F2FC47639F; Mon,  2 Dec 2002 11:41:30 -0500 (EST)
Received: from noaa.gov ([140.90.8.96]) by
	ssmcmail.nems.noaa.gov (Netscape Messaging Server 4.15) with
	ESMTP id H6I3PB00.1GO; Mon, 2 Dec 2002 11:41:35 -0500
Message-ID: <3DEB8D3D.5353D375@noaa.gov>
Date: Mon, 02 Dec 2002 11:41:33 -0500
From: Raymond Chui <raymond.chui@noaa.gov>
Organization: NWS NOAA
X-Mailer: Mozilla 4.75 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-admin@postgresql.org
Subject: CURRENT_TIMSTAMP
Content-Type: multipart/mixed; boundary="------------C2308A989C8C01B2406F9E9C"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/8
X-Sequence-Number: 10596

This is a multi-part message in MIME format.
--------------C2308A989C8C01B2406F9E9C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I created a column, dada type timstamp with time zone
and with default CURRENT_TIMSTAMP
it shows me the default is

default ('now'::text)::timstamp(6) with time zone

Then when I insert a row, the default timestamp value is

yyyy-mm-dd HH:MM:ss.mmmmm+00

where mmmmm is milliseconds.
How do I make default only yyyy-mm-dd HH:MM:ss+00 ?
Thank Q!


--------------C2308A989C8C01B2406F9E9C
Content-Type: text/x-vcard; charset=us-ascii;
 name="raymond.chui.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Raymond Chui
Content-Disposition: attachment;
 filename="raymond.chui.vcf"

begin:vcard 
n:Chui;Raymond
tel;work:301-713-0640 x168
x-mozilla-html:FALSE
url:http://www.nws.noaa.gov/
org:NWS, NOAA;OHD13
version:2.1
email;internet:raymond.chui@noaa.gov
title:CS
adr;quoted-printable:;;1325 East-West Highway=0D=0ASSMC2, Room 8112;Silver Spring;MD;20910-3282;U.S.A.
fn:Raymond Chui
end:vcard

--------------C2308A989C8C01B2406F9E9C--