non-timezoned timestamp column?

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: non-timezoned timestamp column?
Date: 2001-05-01 18:31:29
Message-ID: x7k840dipq.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can one make a non-time zoned timestamp column? I tried this:

create table t1 (
ts timestamp not null default 'NOW()',
tt timestamp without time zone not null default 'NOW()'
);

but both come up with a time zone. The docs only refer to "timestamp"
and "timestamp with time zone", so one would assume that the default
is without, but apparently it is not.

I'm using Pg 7.1 on FreeBSD 4.3.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

Browse pgsql-general by date

  From Date Subject
Next Message Hualin Yip 2001-05-01 19:03:54 how to start postgresql server ( or postmaster ) automatically
Previous Message newsreader 2001-05-01 18:26:50 disk usage advice needed