Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5EExBE35082 for ; Thu, 14 Jun 2001 10:59:11 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f5EEvMt57988 for pgsql-sql@postgresql.org; Thu, 14 Jun 2001 10:57:22 -0400 (EDT) (envelope-from news) From: Vivek Khera X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Timestamp without time zone Date: 14 Jun 2001 10:57:20 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 22 Message-ID: References: <9g9rdu$1k3q$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: scrappy@hub.org User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) To: pgsql-sql@postgresql.org X-Archive-Number: 200106/207 X-Sequence-Number: 3465 >>>>> "PS" == Pasi Salminen writes: PS> I am trying to create table with a field which type is timestamp PS> and I don't want it to be timestamp with time zone. This question has been asked at least 4 times since I've been following this list, including once by me. Appaarently, nobody seems to have an answer. The docs imply that type timstamp is without timezone, since there is a type "timestamp with timezone". If you do a "\d tablename" in psql, it shows "timestamp with timezone" on all your fields you declare as timestamp. This leads me to believe that they are silently "upgraded" in their type. I have a subroutine in my apps that strips the timezone before passing it along to the users. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/