Timestamp without time zone

From: "Pasi Salminen" <pasi(dot)salminen(at)khf(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamp without time zone
Date: 2001-06-14 08:50:20
Message-ID: 9g9tld$1kf4$1@news.tht.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to create table with a field which type is timestamp
and I don't want it to be timestamp with time zone.

If I create the table with the following statement,
field type becomes timestamp with time zone:

CREATE TABLE "test" ("timest" timestamp DEFAULT now());

How can I make a field which type is "timestamp without time zone"?

Regards.

Pasi Salminen

Browse pgsql-general by date

  From Date Subject
Next Message Penguin 2001-06-14 09:06:50 plpgsql & documentation / tutor
Previous Message Tom Lane 2001-06-14 05:55:20 Re: problem connecting from another host