Received: from yertle.kciLink.com (yertle.kcilink.com [216.194.193.105]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5EFSoE48669 for ; Thu, 14 Jun 2001 11:28:50 -0400 (EDT) (envelope-from khera@kciLink.com) Received: from onceler.kciLink.com (onceler.kciLink.com [216.194.193.106]) by yertle.kciLink.com (Postfix) with ESMTP id 119072E45F for ; Thu, 14 Jun 2001 11:28:33 -0400 (EDT) Received: (from khera@localhost) by onceler.kciLink.com (8.11.4/8.11.3) id f5EFSWa20242; Thu, 14 Jun 2001 11:28:32 -0400 (EDT) (envelope-from khera) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15144.55328.741285.104733@onceler.kciLink.com> Date: Thu, 14 Jun 2001 11:28:32 -0400 To: pgsql-sql@postgresql.org Subject: Re: Re: Timestamp without time zone In-Reply-To: References: X-Mailer: VM 6.90 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid X-Archive-Number: 200106/210 X-Sequence-Number: 3468 >>>>> "AP" == Alex Pilosov writes: AP> Why do you _want_ to remove timezone from values in database? There is AP> definitely a way to work around whatever problem you are having. Because my normal date parsing routines from perl's Date::Parse library don't recognize it, and fail to parse the date. % perl -MDate::Parse -e 'print str2time("2001-06-14 12:00:00+04"),"\n";' % perl -MDate::Parse -e 'print str2time("2001-06-14 12:00:00"),"\n";' 992534400 -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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/