Timestamp without time zone - Mailing list pgsql-sql

From Pasi Salminen
Subject Timestamp without time zone
Date
Msg-id 9g9rdu$1k3q$1@news.tht.net
Whole thread Raw
List pgsql-sql
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




pgsql-sql by date:

Previous
From: david.brown@mviva.net (David Brown)
Date:
Subject: arguments for query files
Next
From: "Hunter, Ray"
Date:
Subject: Functions and Triggers