Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 7E9D6475E83; Mon,  2 Dec 2002 16:27:39 -0500 (EST)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP
	id DA3D4475C85; Mon,  2 Dec 2002 16:27:36 -0500 (EST)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 972D8D60C; Mon,  2 Dec 2002 13:27:36 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 84CCB5C02; Mon,  2 Dec 2002 13:27:36 -0800 (PST)
Date: Mon, 2 Dec 2002 13:27:36 -0800 (PST)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Raymond Chui <raymond.chui@noaa.gov>
Cc: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>,
	<pgsql-admin@postgresql.org>
Subject: Re: [SQL] CURRENT_TIMSTAMP
In-Reply-To: <3DEB8D3D.5353D375@noaa.gov>
Message-ID: <20021202132429.A57292-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/12
X-Sequence-Number: 6507

On Mon, 2 Dec 2002, Raymond Chui wrote:

> 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 ?

As already suggested you probably want a timestamp with time zone(0)
column, but if you really want the ability to insert partial seconds but
the default to not have partial seconds, you can use
CURRENT_TIMESTAMP(0) I believe.