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