Received: from localhost.jpl.nasa.gov (IDENT:root@hectic-1.jpl.nasa.gov
	[128.149.68.203]) by hub.org (8.9.3/8.9.1) with ESMTP id BAA16790;
	Fri, 23 Apr 1999 01:23:40 -0400 (EDT)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1])
	by localhost.jpl.nasa.gov (8.8.7/8.8.7) with ESMTP id FAA12102;
	Fri, 23 Apr 1999 05:21:33 GMT
Sender: lockhart@localhost.jpl.nasa.gov
Message-ID: <3720035D.1D8925BF@alumni.caltech.edu>
Date: Fri, 23 Apr 1999 05:21:33 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: chairudin@prima.net.id
CC: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>,
	"'pgsql-admin@hub.org'" <pgsql-admin@hub.org>,
	"'pgsql-interfaces@hub.org'" <pgsql-interfaces@hub.org>
Subject: Re: [INTERFACES] where did that date and time come from??
References: <01BE8A7D.00789480.jt-kirkpatrick@mpsllc.com>
	<371C91C5.2A7E4B4B@alumni.caltech.edu>
	<372039A8.51FDEA58@prima.net.id>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> How about this?
> added datetime default datetime(now()) not null,

Yes, this apparently works by converting from timestamp to datetime.
In general datetime has better dynamic range than does timestamp, but
for calculating 'now' both are equivalent in performance.

                    - Tom

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California