Received: from scl-ims.phoenix.com (scl-ims.phoenix.com [134.122.1.73]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4LKl0A59149 for ; Mon, 21 May 2001 16:47:00 -0400 (EDT) (envelope-from Sandhya_Bellave@Phoenix.com) Received: by scl-ims.phoenix.com with Internet Mail Service (5.5.2650.21) id ; Mon, 21 May 2001 13:46:57 -0700 Message-ID: <1F176F2C2977D311B3300090270E637801C24880@scl-exch.phoenix.com> From: Sandhya Bellave To: pgsql-sql@postgresql.org Subject: Define timestamp with no timezone Date: Mon, 21 May 2001 13:46:56 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200105/232 X-Sequence-Number: 3049 Hi, I have defined a table with a column of type timestamp. The value that I insert into this column is automatically appended with the timezone offset. How do I prevent this? Can I define a column as timestamp with no timezone? Thanks, -Sandhya.